View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lightbulb lightbulb is offline
external usenet poster
 
Posts: 61
Default Conditional Formatting

Is there a way to set conditional formatting by referencing another cell?

For Example I'm setting the formatting for cell E16, and I want it to be
green if cells G16-J16 have a value in them.

Thanks!