Forum Discussion
HOW TO FORMAT EXCEL TO HIGHLIGHT AN ENTIRE ROW BASED ON DATA IN TWO CELLS
I NEED HELP TRYING TO CREATE A FORMULA I need my formula to read two columns ( E & H) and if the columns have yes it will highlight the entire row. If it says no it will highlight a diffrent c...
=AND($E1="yes",$H1="yes")You can try this rule for conditional formatting. In the example i chose green as color and this is the "Applies to" range:
=$1:$26You can adapt the rule for other cell entries and colors as required.