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