Conditional Format of Specific Cell in Variable Length Column

[NoCanDo]

Hi folks

Hope you can help with this one.

I want to write a macro (which will be part of a much larger macro) which identifies in a specific named worksheet if any cell in a particular column does not contain a date or a value, then colour that cell red. The cell(s) could be anywhere in the column.

Note, the column will change it's number of rows between uses.

I've based the following code on cell D5 starting the column and it is obviously identifying soemthing, but it also colours all of the columns A:D red where I only need the actual cell to be coloured.

I'm sure there must be an easy way.

Am getting very confused - please help.

NoCanDo

Please Login or Register  to view this content.

[Leith Ross]

Hello NoCanDo,

This macro will check From cell D5 to last cell with a value in column "D". Only the cells that don't have values will be colored red.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[NoCanDo]

Hi Leith

Many many thanks - works fine - just got to find out how to 'reverse' the process in case someone decides they want to change the data.

If I populate one the cells with a date (as per the other cells) and then re-run the macro, it doesn't take the formatting colour away - how is this done?

Any help is appreciated.

Thank you again.

NoCanDo (But I'm getting better)