1
Thanks

A few words of thanks would be greatly appreciated.

Excel - Conditional formatting for an entire row




Issue


I'm trying to set up a conditional formatting based on the TEXT value of a cell and I want the row to change color if the particular cell has a value = YES or NO
How do I go about setting that up?

Solution


Select the rows and apply the conditional formatting as

Like in example below I want each row in the sheet to turn use conditional formatting if in the corresponding value in B column of that row is "YES"

So I selected all the cells, and went to the conditional formatting and applied this formula

=$B1="YES" 


And change the color to red

Note


Thanks to rizvisa1 for this tip on the forum.
1
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
Related
This document, titled « Excel - Conditional formatting for an entire row », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!