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.
Related
- Apply conditional formatting to entire row
- How to make conditional formatting apply to entire row - Best answers
- Excel conditional formatting row - Best answers
- Copy conditional formatting for an entire row based on one cell ✓ - Forum - Excel
- Conditional formatting on an entire row ✓ - Forum - Excel
- Excel conditional formatting apply to entire column ✓ - Forum - Excel
- Conditional formatting of entire column ✓ - Forum - Office Software
- Excel Conditional Formatting Rows to Columns ✓ - Forum - Excel
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!
