View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shanen Shanen is offline
external usenet poster
 
Posts: 9
Default HELP 4 possible conditions?

Here is my criteria:

80% (cell is green)

60 - 80%(cell is yellow)
< 60%(cell is red)

each cell is populated via link to another workbook cell. If the cell had
"NA" how do either make that cell Grey or at least void the green/yellow/red
criteria?

Thanks!!






--
Shanen