Previous Topic Next Topic

Format one cell based on a text value in another cell

Closed
Nimmo57 Posts 2 Registration date Friday December 18, 2015 Status Member Last seen December 19, 2015 - Dec 18, 2015 at 04:55 PM
 Blocked Profile - Dec 19, 2015 at 06:53 PM
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 responses

Answer 1 / 2
Blocked Profile
Dec 18, 2015 at 06:49 PM
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!
0
Nimmo57 Posts 2 Registration date Friday December 18, 2015 Status Member Last seen December 19, 2015
Dec 19, 2015 at 05:17 PM
If it works then show me! Because I have tried and it does not like the text fiels
0

Similar discussions

Conditional formatting: change fontcolor based on another cell
wandanuila -
Ravi -

18 responses
Change color to different cells based on another cells text.
Riggs2015 -
Riggs2015 -

4 responses
Macro: change cell color based on value in another cell
randal.hite -
TrowaD -

1 response
Formula for if cell contains word, assign value for multiple
hdiesel -
ac3mark -

1 response
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses
change cell by clicking on another cell
Sedicee -
TrowaD -

5 responses