Previous Topic Next Topic

Conditional formatting a cell if a certain word is met

Solved/Closed
scarey3 Posts 4 Registration date Tuesday October 15, 2013 Status Member Last seen February 12, 2014 - Oct 15, 2013 at 02:18 PM
scarey3 Posts 4 Registration date Tuesday October 15, 2013 Status Member Last seen February 12, 2014 - Oct 15, 2013 at 03:09 PM
Hi
I am trying to conditionally format cell B3 if the criteria in cell C3 = NAT I am able to do it if it was a number but not if its a word,
If the criteria NAT is met in cell C3 then colour cell B3 Orange.

Cells B3 and C3 do have formulas in them if this makes a difference.

Regards

Scarey
Related:

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 15, 2013 at 02:24 PM
Select B3

Go to CONDITIONAL FORMAT MENU

1st Condition --> Formula --> =C3="NAT" --> Choose desirable color --> OK
0
Answer 2 / 2
scarey3 Posts 4 Registration date Tuesday October 15, 2013 Status Member Last seen February 12, 2014
Oct 15, 2013 at 03:09 PM
Thank you just did not put the extra = sign in my formula
0

Similar discussions

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

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

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses