Question regarding Microsoft Excel.

Puscifer

Is there a macro I can use that will change the color fill of a cell based on the arrival of a specific date?

For example if I have a column of dates start at Feb 1, 2008. Now at this point, I'd have the cells all colored with yellow fill for example, but I'd like to have each cell color changed to red as soon as that specific date listed in the cell arrived. I.E. on Feb 1st, the color of the cell will change from yellow to red.

I've searched in Excel Help and didn't come up with anything and my searches in Google are coming up with some stuff, but nothing overly useful.

BlochWave

I'm no Excel expert but I'd guess figure out the function command that actually changes the color(like..I dunno, COLOR=3 or however they label the colors)

Then figure out the command that calls the current date(maybe like DATE or DATENOW)then in the cells put an if then else statement, if DATE=such and such then COLOR = such and such else COLOR = something else

Puscifer

BlochWave wrote: »

I'm no Excel expert but I'd guess figure out the function command that actually changes the color(like..I dunno, COLOR=3 or however they label the colors)

Then figure out the command that calls the current date(maybe like DATE or DATENOW)then in the cells put an if then else statement, if DATE=such and such then COLOR = such and such else COLOR = something else

God, I should have thought of that. Been using this program for close to a decade now, I don't know why something simple like that came to mind. Thanks, dude! 8-)

focused7

Use Conditional Formatting. Pre 2007 it's under the format menu. In 2007 it's on the Home tab under styles.

Puscifer

Even simpler solution to that problem. Thanks man. Although, I'm proud of my function I built for this.

BlochWave

Yah Excel is pretty good if you know all the tricks

I don't but one of my coworkers I'm reasonably sure if trapped on a desert island with nothing but Excel, could use it to build sturdy shelter and fire