Thanks Roger.

I am using today() as the comparitive date.

"Roger Govier" wrote:

Hi Dave

If you click on the column header letter to select the whole column, the
active cell is automatically the first cell in that column.

If you clicked on say cell A4, then held your left mouse button down as
you proceeded down the column, on release of the mouse button, you would
have marked a range of cells, but A4 would be the active cell

Are you using the date entered in Cell A1 as your comparative date,
rather than Today() ?
If so, you will need to amend each of Max's formulae, but ensure that
you use an absolute cell reference for the second occurrence of A1 in
the formulae.

=AND(MONTH(A1)=MONTH($A$1)-1,A1<"")

This will make Cell A1 itself, Amber.
If you don't want that, having formatted the whole column, just mark
cell A1 and remove conditional formatting.

--
Regards

Roger Govier


"Dave Dobson" wrote in message
...
Ok. The cell above the one just entered now changes colour.

You say "Select col A": for this I clicked on 'A' to highlight the
whole
column. Did I misinterpret? Please also verify what you mean by
'Active'.
How can a cell be active if the whole column is highlighted?

Thanks.

"Max" wrote:

"Dave Dobson" wrote:
Ok, that worked for a specific cell with a real date.
What if I wanted to apply this to a whole column? ..

If you had selected the entire col A before applying the CF as
suggested in
my earlier response, re line:
Select col A (with A1 active), then apply the CF's formulas /
fills
it would have worked for the entire col A ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---