Afternoon,
Second question of the day regarding conditional formating...
Is it possible to alter the format of a range of cells (using conditional formatting) based on a value/format in another cell?
I have two columns (A/B) which turn dark red if column B>A.
I would like conditional formatting to turn column C to AO the same color if B>A.
Unfortunately, I can only seem to get the format to work based on the value of the specific cell in column C to AO.
Thanks!
Second question of the day regarding conditional formating...
Is it possible to alter the format of a range of cells (using conditional formatting) based on a value/format in another cell?
I have two columns (A/B) which turn dark red if column B>A.
I would like conditional formatting to turn column C to AO the same color if B>A.
Unfortunately, I can only seem to get the format to work based on the value of the specific cell in column C to AO.
Thanks!