Conditional Formatting when a cell says "NO" [Solved/Closed]

Grace C - Jul 18, 2016 at 12:02 PM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen
- Jul 18, 2016 at 02:24 PM
Hello,

I need your expertise in conditional formatting. I have a worksheet that where i have hidden a column ("J") with just Yes and No on it. What i wanted to get is to have any rown in Column "B" highlighted when column J contains "No".

Hoping to get a feedback soon.

Lots of thanks,
Grace
See more 

3 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jul 18, 2016 at 02:16 PM
+1
Helpful
1
Grace C, Good afternoon.

Select the rows you want.
Ex.: 1 to 10

Conditional format menu
Using formula
Formula --> =$J1="NO"
Choose Fill selection any color you want.
OK

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
Hi Marcilio,

A ton of thanks.. this is amazing.. have a wonderful day!!! you made my billing life way easier
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Jul 18, 2016 at 02:24 PM
0
Helpful
Hi Grace C,

>>>> All the best for you <<<<

Thanks for the feedback.
--
Belo Horizonte, Brasil.
Marcílio Lobão