.. All works fine now.

Glad to hear that <g!

If, for example, a month needed to be entered that was
beyond the +/- 1 month from today's date,
how could I change the formula to accomodate this?

Sounds like you want to implement another 2 trigger conditions?

CF allows 3 trigger conditions to format cells, with an implicit 4th (ie
non-trigger condition) being the default format.

You might want to check out Bob Phillips'
CFPlus - Extended Conditional Formatter:
http://www.xldynamic.com/source/xld.....Download.html

Believe it can handle, to quote:
Multiple Conditional Formats, up to 30 in total for any range of cells
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Dobson" wrote in message
...
Thank you. Yes, figured it out at last.

I had used column 'A' in this dialogue just as an example. The actual
column on my sheet is 'I'. Just realised that in my actual column A there
are dates aswell!

All works fine now. If, for example, a month needed to be entered that
was
beyond the +/- 1 month from today's date, how could I change the formula
to
accomodate this?

This perhaps is not as important. I am glad my original problem is now
solved.

Thanks again.