View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt
 
Posts: n/a
Default Conditonal Formatting

I'm trying to use conditional formatting, but I want to have the format
changed for a different cell than where the data is displaying.

For example, 90% shows up in cell A2, but I want A3 to be highlighted in
yellow. Is this possible? I know going to format -- conditional formatting
allows you to set it up, but only for that particular cell.

Thanks for your help in advance.