View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
brett
 
Posts: n/a
Default Conditionally formatting other cells?

If cell A1 is 0, I'd like the text of A1 and B3 thru B10 to be gray. I
know how to conditional format for the current cell but how can I also
format other cells based on the current cell's condition?

Thanks,
Brett