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 so that if a cell is multiplied
by another specified cell it formats as I set it to?

For example, I want the formatting I select (pink coloration) to apply if
the cell is multiplied by cell D46, I want it to be another color if
multiplied by D48, and another color if multiplied by D50.

Any suggestions?

Thanks!