excel script

[ferreseb]

just trying to see if anyone has a script where as users add data into an excel sheet it would show different color fonts as you add data on a different day of week.

monday .. red
tuesday .. blue
.
.
.

 

[xlbo]

not specifically but there are plenty of examples in the VBA forum: Forum707 which should give you some pointers on where to start

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bluedragon2]

Conditional formating gives you four states, you could put

If weekday today = 2 then this font. But like I said, that would only give you four options. I say everyone take Friday off...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...