C
carl
My data looks like this:
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
Is it possible to use the conditional formating to do the following:
If value in ColA is less than value in ColC, cell A1 is shaded blue OR if
value in ColB is greater than value in ColD, cell B1 shaded blue.
Thank you in advance.
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
Is it possible to use the conditional formating to do the following:
If value in ColA is less than value in ColC, cell A1 is shaded blue OR if
value in ColB is greater than value in ColD, cell B1 shaded blue.
Thank you in advance.