I have a drop down menu in column 1 in which participants have to select a
spending option, they have to do this for each row in column 1(approx 15 ).
Once an option is selected I want column 2 to turn red as a reminder that
they have to write a narrative on their spending. Column 2 has rows 1-15
merged together for text input. Here's my problem they might only select 3
or 4 rows out of the 15 (in no particular order) in column 1 to complete -
what is the formula in column 2 (which is merged) so it picks up on any of
the rows completed in column 1 - currently I have =AND(Q1="",L1<"") but it
only picks up data entered into L1 and not the rest (L2-L15) - so if only
rows 5 and 10 are completed column 2 doesn't turn red. Any help is
appreciated.

--
DBW