Applying that conditional formatting will highlight any cell in the row that
is blank.

Counterintuitive, I know, but that's how conditional formatting with
formulas works....

Dave
--
Brevity is the soul of wit.


"LisaVH" wrote:

Won't that only highlight the row if A1 is blank? I want the row to be
highlighted if any cell within that row contains a blank.

"Dave F" wrote:

Select the row in question.

Go to format--conditional formatting and enter the following formula:
=ISBLANK(A1) and select the color you would like to appear.
--
Brevity is the soul of wit.


"LisaVH" wrote:

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?