color/shade cell upon input
Mark,
You could with a Not equal test against a value of "", or a formula of
=LEN(A1)=0
But ... this might slow your spreadsheet down a bit, and it will highlight
all cells that aren't empty, even ones that look empty but have a formula.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"MarkT" wrote in message
...
Greetings,
I have a rather busy worksheet that we use for entering in quantities for
different components and products needed for a manufacturing job.
I would like to have any and all cells shaded in when the user enters in
the
quantity into that cell. The cell would need to be shaded/color added for
both viewing and for printing. I would like this so that the order
pickers
would be able to easily see items needed for the job.
Is this possible without using a conditional formula on each and every
cell
in the spreadsheet?
As in the past, thanks in advance for all your help.
Mark
|