Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formattion of adjacent cell
Can you do a conditional formatting of the adjacent call based on values in
current cell..e.g. if value of A1=0 then B1 cell color should be red |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formattion of adjacent cell
Sure, use the next box down
formula is =a1=0 format as desired -- Don Guillett SalesAid Software "Rajagd" wrote in message ... Can you do a conditional formatting of the adjacent call based on values in current cell..e.g. if value of A1=0 then B1 cell color should be red |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formattion of adjacent cell
Change your thinking to where current cell is to be formatted and adjacent
cell has the value - thus Select B1, then do format, conditional formattiing change Cell Value is to Formula is and use a formula like =A1=0 and select your formatting option -- Regards, Tom Ogilvy "Rajagd" wrote in message ... Can you do a conditional formatting of the adjacent call based on values in current cell..e.g. if value of A1=0 then B1 cell color should be red |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on adjacent cell? | Excel Worksheet Functions | |||
Conditional formattion for whole row based on one cell value | Excel Discussion (Misc queries) | |||
Conditional Formatting-Referencing adjacent cell | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on Value of Adjacent Cell | Excel Discussion (Misc queries) | |||
Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) |