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 formatting formula: =$U2=”Yes” and applies to: =$F:$T, the conditional formatting results are all over the place, highlighting random cells, more wrong results than right ones.
Can anyone help with this issue?
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 formatting formula: =$U2=”Yes” and applies to: =$F:$T, the conditional formatting results are all over the place, highlighting random cells, more wrong results than right ones. Can anyone help with this issue? Read More
