Conditional Formatting

[Mudit.Archna]

Hi,
Objective :
---------------
If Cell-A (A1) value is less than Cell B (B1) Value then paint
(background) CellB with RED else
paint with GREEN.
If Cell B does not have Data then keep background color as white.

Solution I am trying :
------------------------------
Goto Cell B(B1) select Format-->Conditional Formatting -->
Condition1:
CellValueIs Greater than $A1 then Format RED (selecting this
color from the paelete)
Condition2:
CellValueIs less than $A1 then Format GREEN (selecting this color
from the paelete)

Problems:
----------------
1.This does not seem to be working.
2.Auto update of Background color does not happen if the values are
changed (implying the
values are such changed that the conditions are reversed)

Thanks

 

[Pete_UK]

Select cell B1, then Format | Conditional Formatting and in the panel
you need to select Formula Is rather than Cell Contents Is. Set up as
follows:

First Condition: Formula Is : =AND(B1<>"",B1>A1) Background colour:
RED

Second Condition: Formula Is: =AND(B1<>"",B1<A1) Backgound colour:
GREEN

Then OK your way out. Note if A1=B1 there will be no change to the
format. If you want to apply this to other cells use the Format
Painter.

Hope this helps.

Pete

 

[muditg]

Select cell B1, then Format | Conditional Formatting and in the panel
you need to select Formula Is rather than Cell Contents Is. Set up as
follows:

First Condition: Formula Is : =AND(B1<>"",B1>A1) Background colour:
RED

Second Condition: Formula Is: =AND(B1<>"",B1<A1) Backgound colour:
GREEN

Then OK your way out. Note if A1=B1 there will be no change to the
format. If you want to apply this to other cells use the Format
Painter.

Hope this helps.

Pete






- Show quoted text -

 

[Pete_UK]

I'm not sure what you mean. The colours should change immediately if
there is a change in the conditions.

Pete