Conditional Formatting with and rule

[Onecslim]

My apologies if this question has already been asked or if its so simple I shouldn't be asking.

Instead of scrolling through trying to find a date without an initial I want a way to find it quicker and without overlooking a blank cell. Hence, I am trying to format column M to highlight yellow if there is a value (date) in column L. How do I do this? The point is to pull up all the columns without initials so I know there is work to be done. Is it better to run a formula that will pull up this information?

Thank you for your assistance on this basic matter

[#2]

Hello @Onecslim,

I am unaware of a formula to check whether a value is a date, however, you can apply this conditional format to column M to test whether the adjacent value in Column L is a number (dates are stored as numbers in Excel):

=ISNUMBER(L1)

[#3]

Thank you for your response. Is there a formula that will say if Column L has a value and column M is blank highlight column M?

[#4]

@Onecslim 

That could be

=ISBLANK($M1)*NOT(ISBLANK($L1))

applied to column M