Format ROW automatically

0
votes

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.

enter image description here

enter image description here

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

1
excelexcel-formulaexcel-2013conditional-formatting
Create a CF rule based on a formula. If that column of dates was column M then something like =AND($M1>0, $M1<DATE(2015, 8, 31)). - user4039065

1 Answers

1
votes

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