Can the conditional Formatting of the ROW Range be done by viewing the date
entry in Cell $R6 as Text as compared to a Date format?

"Dermot" wrote:

I want to conditional Format Rows depending on there being a date entered in
Cell $R6, so the Row goes Yellow.

If there are no dates within column R6, I want the Cell to remain blank

I have tried using several formula, to no success, the las being,
=IF(DATE(1/1/2001),1,"") .............for condition 1

Assistance would be appreciated how I can achieve this.

Thanks in advance