The below should point you in the right direction. Select rows to be
formatted and use the below CF formula which would check whether the year
returned from the cell is above 1975 and less than 2050....Please note that
this can only be used if you are sure if the numbers in your range are not
more than 27759. Since excel stores date as numbers a number like 27760 is
treated as 1/1/1976..

=OR(AND(YEAR($E1)1975,YEAR($E1)<2050),AND(YEAR($G 1)1975,YEAR($G1)<2050),AND(YEAR($K1)1975,YEAR($K 1)<2050))

PS: Refer help on CELL(info_type,reference) if you are looking for cell
format..


If this post helps click Yes
---------------
Jacob Skaria


"PhilosophersSage" wrote:

I need to conditional format a row based on whither a column (E, G, or K) has
a date (not text or number) is there a way to do this? I can get based on
blank, or number but not just date.