Cell color by day and text

**Scuba Wino** · 10-23-2007, 10:14 AM

Good morning.

New job means new needs.....thank you for looking and your assistance.

I would like to know if this can be done, and if so, how?
I have a spread sheet that goes by days of the month and every day the inventory clerk inputs the daily inventory count onto the sheet.

What I would like to try is: As he inputs the number into that day, have the cell turn yellow and the previous day go back to no fill.

Explain:

A2 to A33 represent the calander day 1-31.
All cells are to be "no color fill"
On the 1st he adds a number to A2, it turns yellow.
On the 2nd, he adds his number to A3.
A2 turns back to "no color fill" (retaining the number) and A3 turns to yellow fill.

Following through to the 31st.

Can this be done?

Thanks for your help.

Scuba

**ChemistB** · 10-23-2007, 12:08 PM

Highlight A2:A33 and go to conditional formatting;

Formula is =AND(ISBLANK(A3),NOT(ISBLANK(A2))) and set your formatting however you want. This will format the cell if the next cell is blank and that cell is not. Does this do what you want?

ChemistB

**Scuba Wino** · 10-23-2007, 06:01 PM

I appreciate the input, but either I am not doing it correctly or it isn't the solution I am looking for (at this time...)

Thanks

**Scuba Wino** · 10-24-2007, 04:30 PM

Bump.

Still stuck. Anyone have an idea.

Thanks

**VBA Noob** · 10-24-2007, 04:32 PM

A example file may help.

Not sure what number will be entered

On the 1st he adds a number to A2

VBA Noob

**Scuba Wino** · 10-29-2007, 11:31 AM

Originally Posted by VBA Noob

A example file may help.

Not sure what number will be entered

VBA Noob

My inventory technician inputs a daily inventory to his cell for that day. For example, what I'd like to do is:

In A1 he enters his count for that day (the 1st of the month). That cell now turns yellow.

On the 2nd of the month (the next day) he enters his count into A2.

Now, A1 is to turn back to no fill color and A2 is to turn yellow.

Thanks

SW