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

Ask a question Grace C - Last answered 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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!