Hi LisaVH,

your column A,C,E... contains hard data one column per day
your column B,D,F...contains your formulated total to date one column per day

if there is a missing data on column A or C or E or on the Last formulated
column, say F..

you want to make the whole row as yellow

try in conditional format
select one row with data (e.g. row(22))
formula is :
=(COLUMNS(22:22)-COUNTBLANK(22:22))<MATCH(LOOKUP(2,1/(22:22<""),(22:22)),22:22,0)
select color yellow as patterns.

there are other shorter formula for this cond. format which can be solicited
in this forum, from others.

regards...

--
*****
birds of the same feather flock together..



"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?