CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
 

I am trying to format a cell to turn a color when a date (any date) is
entered into it.

Thank you.

CONDITIONAL FORMATING/COLOR CELL WHEN FILLED
 

You need a UDF

Function HasDate(rng As Range)
If rng.Count = 1 Then
HasDate = IsDate(rng.Value)
End If
End Function

and use that in you CF formula


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mark Warner" wrote in message
...
On the conditional format menu I use 'Cell Value is', 'Equal to', and '0'
when the cell is blank to add the color to it.


"vdefilippo" wrote:

I am trying to format a cell to turn a color when a date (any date) is
entered into it.

Thank you.