I want text in Columns F&H and numbers in columns G&I to change color based on the text in column E.
I have tried to use the conditional highlighting under Format-cell-conditional fighting and set rules.
I cannot get the desired results using this route.
thanks
Mac Pro, OS X El Capitan (10.11.6), 4,1 Early 2009 8 GB Memory
Hi jms,
Conditional highlighting rules compare the value in the cell to be highlighted to another value—either a fixed value written into the rule, or the value in another cell.
"I want text in Columns F&H and numbers in columns G&I to change color based on the text in column E."
To do this directly, you need to be able to write a rule that compares the text (or number) in columns F and H (or in columns G and I) with the text in column E, and come up with a TRUE result when the cells in columns F-I should be formatted, and a FALSE result when they should not be formatted. This is likely an impossible task, so…
You'll need to take an indirect approach, using four auxiliary columns, one for each cell to be formatted.
Each of the cells in the new columns neds a formula that reads the value in column E, compares it to the value that is to trigger the colour change in the text/number in that row of columns F-I, and sets the value in the cell in that row of the new columns to match the values in its partner column if E contains the trigger value or to a value not matched by the value in its partner column if E does not contain the trigger value.
Example:
(Can't post screenshot of example as website refuses to proceed past 'choose image'. Will try again.
Meantime, if you want a solution for the specific issue, you'll need to provide information regarding the value(s) in column E that will trigger the colour change, and an indication of what causes that (those) values to be displayed in column E.
Regards,
Barry
Hi jms,
What you want to do is possible in Numbers.
Barry wrote:
You'll need to take an indirect approach, using four auxiliary columns, one for each cell to be formatted.
You can hide those auxiliary columns.
Barry wrote:
you'll need to provide information regarding the value(s) in column E that will trigger the colour change, and an indication of what causes that (those) values to be displayed in column E.
Please help us to help you.
Perhaps you could post a screen shot of a small part of your table. Please include Column labels (A, B, C, etc) and Row labels (1, 2, 3, etc).
More information will lead to a solution 🙂.
Regards,
Ian.
Conditional Highlighting in Numbers
