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

scarey3 4 Posts Tuesday October 15, 2013Registration date February 12, 2014 Last seen - Oct 15, 2013 at 02:18 PM - Latest reply: scarey3 4 Posts Tuesday October 15, 2013Registration date February 12, 2014 Last seen
- 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

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Oct 15, 2013 at 02:24 PM
0
Thank you
Select B3

Go to CONDITIONAL FORMAT MENU

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