Coloring a range of cells based on a time frame.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mahnian - 25 Jan 2007 23:31 GMT

I am in need of some help.

I have to get a sheet made that will auto color a row green based on a time
frame.

Example:

On sheet1 we show John works from 07:00 to 16:00
On sheet2 we would need to have to color b2:al2 green (each cell represents
15 minutes)

This had to be dynamic as individual shifts will change from time to time,
and my boss-man does not want to color it by hand.

Anyone have any insight?

Reply to this Message

macropod - 26 Jan 2007 02:48 GMT

Hi Mahnian,

You could use Conditional formatting. This gives four colour possibilities -
the default colour and up to three conditional colours - but for your stated
purpose, one will do. If you want more than 3 conditional colours, you'd have
to use a macro.

Cheers

Signature

macropod
[MVP - Microsoft Word]

| I am in need of some help.
|
[quoted text clipped - 11 lines]
|
| Anyone have any insight?

Reply to this Message