I have a database that is filled out by our staff, and the line of infor
(a1-r1) is in black, when the DA's office takes the case, and fills in a date
in cell (w1) , I want the entire line a1-w1 to turn blue, so we can glance at
the spreadsheet to see what is still open in our office. Is there a way to
set a format that when w1 is filled out the entire line turns from black to
blue?

Thanks,