Cell formatting issue


I seem to be having an issue with cell formatting. I have set up formatting for cells to turn red/green, I then added a rule to make the whole row white if the date in the date column is in the future...

For some reason although the white row rule is at the top it is not applying this above the others?

Thanks, Will.

Best Answer