Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

How to format cells based on the text in another cell

[Solved/Closed]
Report
Posts
2
Registration date
Thursday October 30, 2014
Status
Member
Last seen
October 31, 2014
 -
Posts
2
Registration date
Thursday October 30, 2014
Status
Member
Last seen
October 31, 2014
 -
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

Answer 1 / 1
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
 144
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
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Report
Posts
2
Registration date
Thursday October 30, 2014
Status
Member
Last seen
October 31, 2014
Yes, it worked! Thank you!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!