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

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<"",B1A1) 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

On Jul 11, 11:17 am, wrote:
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

On Jul 11, 3:46 pm, Pete_UK wrote:
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<"",B1A1) 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

On Jul 11, 11:17 am, wrote:



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- Hide quoted text -

- Show quoted text -

------------
Is there some thing that can be done so that the background color gets
updated automatically if the value in the are modified ?

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

Pete

On Jul 12, 7:58 am, wrote:
On Jul 11, 3:46 pm, Pete_UK wrote:





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<"",B1A1) 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

On Jul 11, 11:17 am, wrote:

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- Hide quoted text -

- Show quoted text -

------------
Is there some thing that can be done so that the background color gets
updated automatically if the value in the are modified ?- Hide quoted text -

- Show quoted text -