Conditional formatting a cell if a certain word is met [Solved/Closed]

Posts
4
Registration date
Tuesday October 15, 2013
Last seen
February 12, 2014
- - Latest reply: scarey3
Posts
4
Registration date
Tuesday October 15, 2013
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
See more 

2 replies

Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
0
Thank you
Select B3

Go to CONDITIONAL FORMAT MENU

1st Condition --> Formula --> =C3="NAT" --> Choose desirable color --> OK
Posts
4
Registration date
Tuesday October 15, 2013
Last seen
February 12, 2014
0
Thank you
Thank you just did not put the extra = sign in my formula