View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Marissa Marissa is offline
external usenet poster
 
Posts: 7
Default Conditional Formatting Nested Formulas

I'm working with a large spreadsheet that has multiple status options. Each
status has different criteria for example:

Status Green Yellow Red
T <60 =60,<=80 80
S <20 =20,<=45 45
D <30 =30,<=55 55
C <90 =90,<=120 120
B <30 =30,<=60 60
A <10 =10,<=40 40

I would like to apply conditional formats according to the status criteria.
Is that possible given that each status has a different criterial. Thank you!