Condition font color in a single cell based on its formula data.

[Bee]

I have a formula within a single cell that contains a formula to sum up a
column. I want that same cell to reflect its sum data in red font if the sum
is less than 35 and green font if the sum is equal to or greater than 35.
How can I do this? Please help. Thank you, in advance, for your time.

 

[Gord Dibben]

Format>Conditional Formatting.

Cell value is <35 format to red font.

Add>Condition 2 Cell Value is equal to or greater than 35 format to green font


Gord Dibben MS Excel MVP

 

[Bee]

Thank you so much. I'm retired and had forgotten how to format conditions in
a cell. I remembered how shortly after I posted my question and then didn't
know how to cancel the posting!! I appreciate your reply and time.

 

[Gord Dibben]

You cannot cancel postings after you hit the "go" button.


Gord