Format ROW automatically

Question

I used conditional formatting to change the fill color of cells with dates before 31/08/15. But, I wanted to format the whole row, not a single cell.

Here are my settings in Conditional formatting.

Kindly suggest tweaks and workarounds, I have searched lots of formulas, but none fits to copy the format to the others cells/row.

Answer 1

Jeeped's formula will work, just remember to change the range in the 'Applies to' box to include all the columns in your row:

=AND($O2>0, $O2<DATE(2015, 8, 31))

Conditional formatting rules manager / Applies to:

=$A$2:$O$899