I appologize if this question has been asked, I could not find anything close
enough in the archives.

I am not sure that this is possible,but here goes....I have a spreadsheet
that keeps a running daily total for a set of locations. Each day I add
another two columns. "A" is todays data "B" is total to date, then "C" will
be the next day's data and "D" will be that day's total to date. What I want
is to have the entire row turn yellow is there is a blank cell anywhere in
that particular row. This will tell me if there is data missing and that on
day 2 the total to date is not correct. One problem I keep thinking that if
I do set this up, how do I tell it not to look that the empty rows after my
last day? Do I need to set up a range? Will I have to keep changing the
format as I add new days?