Conditional Formatting Dates calculating 10 days and 30 days from a certain date
Hi there,
I have a spreadsheet as follows:
Column A Column B Column C Column D
04/09/2007 Ann Other 14/09/2007 04/10/2007
04/09/2007 Joe Bloggs
05/09/2007 Trudy Roundwindow
05/09/2007 Duncan Disorderly
10/09/2007 Gerry Cann
What I’d like to do is:
1. Use a formula or conditional formatting to make the date appear
automatically in the Column C, calculating 10 days from the date that
appears in Column A and formatted so that it appears in Red
2. Use a formula or conditional formatting to make the date appear
automatically in the Column D, calculating 30 days from the date that
appears in Column A and formatted so that it appears in Red
I know it’s something to do with Conditional Formatting and the TODAY()
function but I’m stumped as to how to do it.
Hope I've explained this sufficiently
Any solutions please?
Thanks in advance
Sioux
--
Sioux
|