Forum Discussion
Conditional formatting on row based on text result from formula from another cell
I am trying to format the cells in a row between columns F-T based on the result of "Yes" from column U containing the IF formula =IF(J2=M2,"Yes","No"). When I apply the conditional form...
Your conditionally formatted region is $F:$T, that is a range that starts at cell F1. That means your conditional formatting formulas should be specified relative to F1, not F2.
= $U1 = "yes"
or, equvalently
= $J1=$M1