Previous Topic Next Topic

How to format cells based on the text in another cell

Solved/Closed
Tillda Posts 2 Registration date Thursday 30 October 2014 Status Member Last seen 31 October 2014 - 30 Oct 2014 à 18:14
Tillda Posts 2 Registration date Thursday 30 October 2014 Status Member Last seen 31 October 2014 - 31 Oct 2014 à 16:30
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

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
30 Oct 2014 à 19:18
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 30 October 2014 Status Member Last seen 31 October 2014
31 Oct 2014 à 16:30
Yes, it worked! Thank you!

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses