Having a mental block this morning.
From B5:B1000 I have values that result from
a MAX function. If when all is said and
done, and all my vaules in this range are
> $0.00, I want to turn B1 Green. If not,
then RED. A simple flag to tell me the
Spreadsheet is completed. (Unless you have
some other brilliant way to show this, like
having fireworks go off or something ).
Thanks for your help as always,
Mike
From B5:B1000 I have values that result from
a MAX function. If when all is said and
done, and all my vaules in this range are
> $0.00, I want to turn B1 Green. If not,
then RED. A simple flag to tell me the
Spreadsheet is completed. (Unless you have
some other brilliant way to show this, like
having fireworks go off or something ).
Thanks for your help as always,
Mike