Is there any way to have an entire row shaded based on a value in that row. I
want rows to be shaded once if a date in the row has passed.

I have tried using the =IF($V3<TODAY,1,0) and then selecting my shading
colour, having highlited the entire row, but nothing happened. Any help would
be greatly apprecaited.