View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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