Conditional formatting

paul1hudson 

You're giving slightly different information between your two postings. So I'm going to have to make a couple of assumptions.

Your original message said that column 1 was red or amber; this latest says red or yellow.

More significant perhaps, though it depends on how it's coded, your first message said that the second column contains a "No" in order to activate this desired red flag; your latest message says "0"

I'm sorry to be a nit-picker, but the fact of the matter is that the conditional formatting function IS itself very much a nit-picker, which is why it can be tricky to get it doing exactly what you want it to do.

So I've made a couple of assumptions in giving you an example file (attached) where:

• the date turns red if it's the current month or earlier; yellow if next month, remains white if further in the future.
• The Paid column (I have two of them) turns red on the basis of a zero or an "N" along with the month being red. It turns yellow if N or zero and the month is yellow. I saw no reason to not stick with the same "warning" color ....  

Here's what it looks like.  Test it by changing values in columns A, B or C

You can read the conditional formatting rules involved by selecting "Conditional Formatting" either through the "Format" menu across the top of the screen

OR through the Conditional Formatting icon on the tool bar