My conditional formatting formula is ="if(and($K3="""",$J3<(today())"
Problem is I need to copy that conditional format to the rest of the spreadsheet. When I use the Format Painter, the next row has the same conditional format. It needs to be ="if(and($K4="""",$J4<(today())"
Any way of getting excel to fill the series in conditional format??
Bookmarks