Change cell colour on date

[Orangeanorak]

Can you give me a formula to chenge a cell to a particular colour on particular dates
i.e. B10 blue on 10th March and grey on 15th March

Thanks

 

[njimack]

Since you didn't specify a year, the below will work regardless of the year entered...

Excel Workbook
	B
10	10-Mar
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10	1. / Formula is =AND(DAY(B10)=15,MONTH(B10)=3)	Abc
B10	2. / Formula is =AND(DAY(B10)=10,MONTH(B10)=3)	Abc

 

[Orangeanorak]

Thanks a lot
Much appreciated