Excel Questions

  • Thread starter Thread starter Claudine Phoebe
  • Start date Start date
C

Claudine Phoebe

How do I custom format the following: Put any number < 30
in red and parenthesis and any number > 30 in blue.

How do I used a named range in reference to another valued
cell?

How do I create a history summary for a Pivot table?

Thanks for your assistance.
 
Hi claudine
apply the following custom format for this cell:
[Red][<30](0.00);[Blue]0.00
 
Back
Top