Format one cell based on a text value in another cell [Closed]

Report
Posts
2
Registration date
Friday December 18, 2015
Status
Member
Last seen
December 19, 2015
-
 Blocked Profile -
Hi
I'm trying to change the colour format of one cell with a text value based upon the text value of another cell, but cannot get it to work in excel for mac 2011.
I am using both Windows and mac versions.
I.e. cell A1 has a text value of "y" and cell b1 has a tick . Cell A1 needs to change colour to yellow.
Cell A1 has"N" B1 has a tick A1 needs to be red.

I am using values of data validation in A1 of "y", "n" and 'n/a" therefore making cell a1= n to verify the condition will still give me a red format which I do not want with"n/a"


If anyone can get this to work in "NUMBERS" that would also be appreciated

Help!
many Thanks

2 replies


Welcome! You are looking for Conditional Formatting! You can set a formula up, and set conditions for colors!

Let us know if you get stuck setting it up!
Posts
2
Registration date
Friday December 18, 2015
Status
Member
Last seen
December 19, 2015

If it works then show me! Because I have tried and it does not like the text fiels


Your Wish Is my Command! Use A Formula, not a cell value!

Have FUN!