Highlighting range of cells

**neilq5** · 06-08-2012, 06:45 AM

I'm designing a day to day appointment intake diary for a vehicle training company.

I have attached a screenshot of the set up i have below to simplify things.

The dropdown menu's is of the instructors and the cells below will be of the appointments and customers they have that day.

In the cell next to CBT i want to make it that the user can either enter Y/N:

If Y is entered all the cells in that instructors columns for that day will turn red which means there not available for appointments.

If N is entered all the cells will turn green which means they are available for appointments.

i plan to use autofill to add as many additional days as i can while bringing the formatting with it.

how would i go about this?

i'm still quite new to excel so be as detailed as possible.

I really appreciate any help i can get!

**arlu1201** · 06-08-2012, 06:50 AM

It will be good if you attach a sample excel file instead of a png.

**Fotis1991** · 06-08-2012, 06:54 AM

Hi

You will need Conditional formatting for this

Hiqhlight for example range D4:D100 and in CF rules, put this.

=$d$2="Y") Choose red color. Same way for Green.

Is this, works for you?

If you can not handle this, pls, upload a small sample workbook.

**neilq5** · 06-08-2012, 06:58 AM

Apologies, here's a sample worksheet

**neilq5** · 06-08-2012, 07:07 AM

Thanks for the help fotis1991 i got it to work!

Is there any way i can copy this formatting down on to my next day and keep going instead of having to enter in the formatting manually for each day?

**Fotis1991** · 06-08-2012, 07:12 AM

Where next starts? In A26?

**neilq5** · 06-08-2012, 07:28 AM

next start will be A54 as i have other information under each day that does not need formatted

i have added my updated worksheet below

I have just added the Y=red option for now until i get the hang of it.