Conditional formatting nested if/and/or based on cell vaule date

[Kirsty05]

Hi, I've been asked to format a table showing the following:

If N6 contains a date, make the row red.
If K6 and N6 contain dates, make row yellow.
If O6, K6 and N6 contain dates, make row orange.
If P6, K6, N6 and O6 contain dates, make row green.

I'm using Excel 2016.
I've tried everything I can think of and I'm stumped. Any help gratefully received!

 

[jasonb75]

Dates are nothing more than numbers, the easiest way would be to count the cells.

Red rule =COUNT($N6)=1
Yellow rule =COUNT($K6,$N6)=2
Orange rule =COUNT($K6,$N6,$O6)=3
Green rule =COUNT($K6,$N6,$O6,$P6)=4

Empty cells or cells with text will not be counted. If the same cells can contain numbers other than dates then it can be difficult to identify which ones are dates.

 

[Kirsty05]

Dates are nothing more than numbers, the easiest way would be to count the cells.

Red rule =COUNT($N6)=1
Yellow rule =COUNT($K6,$N6)=2
Orange rule =COUNT($K6,$N6,$O6)=3
Green rule =COUNT($K6,$N6,$O6,$P6)=4

Empty cells or cells with text will not be counted. If the same cells can contain numbers other than dates then it can be difficult to identify which ones are dates.

You are an absolute legend, thank you. I was hung up on the dates x