How to change the color of two cells using Conditional Formatting ?

[demianill]

Hi all !

I have a Plan with two columns, A and B. In both, I'm already usin
Conditional Formatting to change the color of the data in the cell
like this:

In the cells of column A, IF value are *>* 95, then change font colo
to red.
In the cells of column B, IF value are *<* 5, then change font colo
to red.

How can I change the *background* color of BOTH cells, if the tw
conditions above are reached ?

For example, if A12=96 *AND* B12=4.88, then background color of cell
A12 and B12 must be yellow. It's important to keep the font colo
red, too.

Please, help me !!

Thanks a lot !!

Demian

 

[JE McGimpsey]

One way:

Select column A (with cell A1 active). Use

CF1: Formula is =AND(A1>95,B1<5)
Format1: Font/Red
Patterns/Yellow

CF2: Formula is =A1>95
Format2 Font/Red

Do the same thing for column B (B1 active):

CF1: Formula is =AND(A1>95,B1<5)
Format1: Font/Red
Patterns/Yellow

CF2: Formula is =B1<5
Format2 Font/Red

 

[swatsp0p]

Conditional Formatting allows you to test for up to three variations.
Simply use the following two conditions in A2:

Condition 1: Formula is: =AND($A2>95,$B2<5)
set font to Red and Pattern to Yellow

click Add

Condition 2: Cell Value Is: Greater Than: 95
set font to Red (don't enter a value for Pattern)

Click OK

Copy this formatting to B2 (Copy A2 >Paste Special>Formats) and edit
the 2nd condition to be Less Than: 5

Then copy these formats down A & B as needed.

Does this work for you?

Bruce

 

[Dodo2u]

Hi all !

I have a Plan with two columns, A and B. In both, I'm already using
Conditional Formatting to change the color of the data in the cell,
like this:

In the cells of column A, IF value are *>* 95, then change font color
to red.
In the cells of column B, IF value are *<* 5, then change font color
to red.

How can I change the *background* color of BOTH cells, if the two
conditions above are reached ?

For example, if A12=96 *AND* B12=4.88, then background color of cells
A12 and B12 must be yellow. It's important to keep the font color
red, too.

Please, help me !!

Thanks a lot !!

Demian.

Double conditional formatting!

For cell A12:
Condition 1: Formula is =AND(A2>95, B2<5)
Condition 2: Cell value is larger than 95

For cell B12:
Condition 1: Formula is =AND(A2>95,B2<5)
Condition 2: Cell value is smaller than 5

In the conditions 1 you set the font colour to red.
In the condtions 2 you set the font colour to red and the pattern to
yellow.

You can Copy and Paste special/Format this to the other cells in A and B.

Do not reverse the conditions as the first condition met will be the one
and it stops there!