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

Ask a question Grace C - Latest answer on Jul 18, 2016 02:24PM
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,
See more 
moins plus
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.

Is this what you want?
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
Grace C- Jul 18, 2016 02:21PM
Hi Marcilio,

A ton of thanks.. this is amazing.. have a wonderful day!!! you made my billing life way easier
Add comment
moins plus
Hi Grace C,

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

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

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!