Hello all,
I have a table with two columns. Column A contains text strings. These require to be formatted either red or green.
Column B has values varying from 1 to 10. I want the text in Column A to be formatted as per the value in their row within Column B. In this case, over 4 is green, under 5 is red.
You can easily format based on a single value in a single cell but there are different values in Column B. This is where google gets stuck for me. I could do this based on a rule for each row, but want to do this all on one rule.
Many thanks for anyone who can help.
Cheers
Bookmarks