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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Excel Count If Formula Question 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
default values in a cell 1
Excel Conditional Formatting 1
negative currency abbreviated format 1
Access #Error & Excel Pivot 0
Sum function problem 7

Back
Top