View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shadyhosta Shadyhosta is offline
external usenet poster
 
Posts: 6
Default Formula to print a datum in color contingent on value.

I need a formula that will change the displayed color of a value based on
amount.
For example: under 200=yellow, over 200=red.
Also, can I add input from a third column?
For example: under 200 and Column D=No, then yellow.
under 200 and column D=yes, then green.