Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting help | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |