conditional formatting

[Jaugenblick]

How can I change the background on a group of cells base on data in each cell.

I am creating a monthly schedule and would like to pick a persons name from a list and have it highlite the days they are listed on.
I have 31 days down and a max of 5 persons per day across.

 

[Aladin Akyurek]

On 2002-04-13 03:01, Jaugenblick wrote:
How can I change the background on a group of cells base on data in each cell.

I am creating a monthly schedule and would like to pick a persons name from a list and have it highlite the days they are listed on.
I have 31 days down and a max of 5 persons per day across.

Make a list of the relevant persons in a sheet you could name Admin. Select all of the names of this list, go to the Name Box, type NAMES, and hit enter.

Go to the sheet where you have that 31 days-schedule. If row 1 is not free, insert a row before the first row your data.

Activate say A1 in row 1.
Activate Data|Validation.
Select List for Allow.
Enter as Source:

=NAMES

Activate OK.

Now select the schedule range (I'll assume here: B3:F100).
Activate Format|Conditional Formatting.
Choose Formula Is for Condition 1.
Enter as formula:

=B3=$A$1

Activate Format.
Select a color to your liking on the patterns.
Activate OK, OK.

 

[Jaugenblick]

Thanks for the help it worked great.