Change colour of cells depending on date AND turn row BOLD on receipt of payment

Originally Posted by Kevin UK

Hi altern8baby

See the attached file.

On the Sect cells in Column H > Home Tab > Conditional Formatting > Manange Rules > Click A Rule > Edit Rule. To see the formulas that apply the conditions.

Hi Kevin,

Thanks for giving it a go.

For some reason, only 3 of the dates have changed colour, and not the right colours!

I've had a look at the formula in conditional formatting and can't see how to fix it