Community archive

Ask something
Discussion Locked

Excel Colors in Formulas

0 helpful
3 replies

by breese55

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by lvn

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.

by skidoggeruk

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.

by lvn

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

This discussion is closed to new replies.