Thread: Conditional formating-change color of cells over than one with for
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
carrera carrera is offline
external usenet poster
  
Posts: 52
Default Conditional formating-change color of cells over than one with for
Let's say in D55 on each sheet is a formula showing a cumulative total from
the prior sheets

If the cumulative total in D55 is less than 40, I'd like cells in rows 1
through 49 to be green, if over 40, turn the cells red.

In other words, can I make the condition formating dependant on a totally
different cell?
Reply With QuoteReply With Quote