Conditional Formating

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

Max

carl said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top