Conditional Formating
 

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.

Conditional Formating
 

"carl" wrote:
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.

One interp ..

Select col A
Click Format Cond Formatting
Cond1, Formula is: =A1C1
Format to taste OK out

Select col B
Click Format Cond Formatting
Cond1, Formula is: =B1D1
Format to taste OK out

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---