How to format cells based on the text in another cell

Solved/Closed
Tillda Posts 2 Registration date Thursday October 30, 2014 Status Member Last seen October 31, 2014 - Oct 30, 2014 at 06:14 PM
Tillda Posts 2 Registration date Thursday October 30, 2014 Status Member Last seen October 31, 2014 - Oct 31, 2014 at 04:30 PM
Help me!
I'm trying to conditionally format multiple cells based on different texts entered in another. For example: I have selected certain cells to highlight based on this formula

=AND($F$5="New Hire")

That works, but when I try to format some (not all) of those cells to highlight if the text in F5 is Promotion using the same formula nothing happens.

What can I do for it to recognize that the cells need to be formatted based on different text?

Thanks in advance.

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 30, 2014 at 07:18 PM
Tillda, Good evening.

Are you trying to highligh the cells if F5 is New Hire OR Promotion?

If Yes, try to use it:

=OR($F$5="New Hire",$F$5="Promotion")

Is it what you want?
I hope it helps.
Tillda Posts 2 Registration date Thursday October 30, 2014 Status Member Last seen October 31, 2014
Oct 31, 2014 at 04:30 PM
Yes, it worked! Thank you!
0