Jan 01 2019 04:38 AM
On my budget spreadsheet, I want to show actual figures in red, if they exceed budgeted figures. How do I do this?
Jan 01 2019 01:13 PM
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.
Jan 01 2019 01:30 PM