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

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

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