Highlight Row Based On One Cell Value (1 Viewer)

[.Justin]

I have the following:

What I want is if the Highlight Collumn has Yes in it, to highlight that row. I have gone to conditional formatting selected Use a formula to determine which cells to format however I cannot work out the formula to select if yes?

I have tried IF(E2="Yes") and this doesn't work clearly I have the wrong formula!

Justin

 

[Ranman256]

Yes is not text, it's numeric,
True =-1
False=0

 

[.Justin]

Yes is not text, it's numeric,
True =-1
False=0

I think I get what your saying... So how would I write the formula?

 

[Rx_]

Go to conditional formatting for the Yes cell, enter anything.
Go back to conditional Formatting Rules Manager (see attachment)
This provides a little clearer idea of what is happening.
Note that I fixed the location of the Columns with the $
but not the rows ($C2)
Then fixed the Applies to for that one row.

The Format Painter is your friend in Conditional Formatting.
Highlight the first Row, then apply it to rows below.

For a slightly different process to accomplish the same thing:
https://exceljet.net/tips/how-to-highlight-rows-with-conditional-formatting
Note at the end, they created a fixed cell for the Match.
My preference is to make that matched cell a data link to another range so it has a pull down listbox. This can make data analysis very dynamic.


Above is a Macro Free method.
Please mark this as Solved