G
Guest
I am tring to get the font color for an entire row to change based on the
value of a cell in the row. For example, B1 = TRUE B2= FALSE and B3 = FALSE.
I would like the font color for all of row 1 to be red based on the fact that
B1 equals TRUE and the font color of the other two rows to remain black based
on the fact the the value in their respective B columns does not equal TRUE.
I tried conditional formatting but can only get the font in cell B1 to turn
red not all of row 1.
value of a cell in the row. For example, B1 = TRUE B2= FALSE and B3 = FALSE.
I would like the font color for all of row 1 to be red based on the fact that
B1 equals TRUE and the font color of the other two rows to remain black based
on the fact the the value in their respective B columns does not equal TRUE.
I tried conditional formatting but can only get the font in cell B1 to turn
red not all of row 1.