Thread: Formula for fill color?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
  
Posts: 857
Default Formula for fill color?
Assume you're looking for the formula to put in the conditional format for
G2, try this:

=AND(G2D4, G2<D6)


" wrote:

I'm trying to say "If D4<G2<D6, then make G2 a certain color". any
ideas? I keep getting errors. thanks!


Reply With QuoteReply With Quote