View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Soumadip Soumadip is offline
external usenet poster
 
Posts: 1
Default How to change cell color with reference to a formula?

I want to change the color of a cell with conditional formatting.That means
the
cell color Value
Red 0-97
Yellow 97.01-99.99
Green 100
White the cell is blank
The problem is in conditional formatting we can use only 3 formulas.So how
to do it?