One of my main sources for these blog posts are questions I get from my subscribers and class participants. Recently I had one of my participants ask for help. He had applied conditional formatting to numbers – the idea would be that if the number was greater than a target number on the same row – it would go red. However he found that when he entered NA for some of the entries…Excel kept colouring those entries red as well. It turns out that the solution was to put in a rule at the beginning that said – if this entry is text, stop the conditional formatting right there.. Let’s have a look.
- Two ways to group your numbers in Excel
- Creating a simple accounting system – Part Three – ~Another way to summarize your payments
- Creating a simple accounting system – Part Two – Summarizing your payments
- Creating a simple accounting system – Part One – tracking your payments
- How to summarize multiple CSV files – in minutes