General discussion

Locked

Excel Colors in Formulas

By breese55 ·
I hope I put this in the right spot.

I would like to use a calculation in Excel and have the resulting calculation show in different colors dependent on that calculation.

Let's say the answer was 500. I would lke the 500 to show up in Blue type. If the answer was 499, it would be green type. I have sevral applications to use this on. In log colums, it would help me to pick out certain final calcuations easier.

You can send me an email to: breese@thegateway.net

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Use Conditional Formatting Command

by lvn In reply to Excel Colors in Formulas

On the Menu Bar, click Format, Conditional Formatting--it will be obvious based on the window that displays how to set it up from that point on.

Collapse -

how many levels of Conditional formatting

by Skidoggeruk In reply to Use Conditional Formattin ...

I seem to remember that there are only so many levels of conditional formatting. Hope you don't need a lot, as I think you only get three.

Collapse -

You're correct

by lvn In reply to how many levels of Condit ...

Yes, there are only 3 levels of conditional formatting available, however it does allow for ranges if that will help at all.

Back to Community Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums