Conditional Formating

[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.

[Max]

"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: =A1>C1
Format to taste > OK out

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

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