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

Report
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014
-
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014
-
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

2 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Select B3

Go to CONDITIONAL FORMAT MENU

1st Condition --> Formula --> =C3="NAT" --> Choose desirable color --> OK
Posts
4
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
February 12, 2014

Thank you just did not put the extra = sign in my formula