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.

Conditional formatting – that excludes text entries

You can download the file I used here.