Help with Conditional formatting

Occasional Visitor

On my budget spreadsheet, I want to show actual figures in red, if they exceed budgeted figures. How do I do this?

2 Replies

Highlight the figures in your book, then press the conditional formatting button and "highlight cells rules" in the dropdown menu. Then you can press greater than, enter the value not to be exceeded, make sure it's in red, and now your conditional formatting should work. 


If it doesn't, post back, I may have forgotten something.

Pressing NUMBER FORMAT did nothing either. this thing is driving me nutz...
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies