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 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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.
1
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