Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Change the colour of a bunch of cells, based on one cell.
Hi,
I have a montly on-call roster which is colour coded for each person on the roster. I have set it up that if you put a name in the Thursday afternoon session, it replicates the name through to the NEXT Thursday morning. HOWEVER, I would like to also modify the colour of those fields, so that if the person on-call swaps with another person, instead of using the Formatter Painter and changing each group of cells, it does it automatically. Something like IF (E14 = "Bob", (CELL.Colour="Red",CELL.Text="Bob"), IF (E14 = "Fred", (CELL.Colour="Blue",CELL.Text="Fred"), (CELL.Colour="Green",CELL.Text=E14) ) I have set the above out as follows IF THEN ELSIF THEN ELSE Any ideas. Cheers Craig. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Change the colour of a bunch of cells, based on one cell.
Hi
for only 3 persons you could use 'Format - Conditional Format' for this -- Regards Frank Kabel Frankfurt, Germany Craig & Co. wrote: Hi, I have a montly on-call roster which is colour coded for each person on the roster. I have set it up that if you put a name in the Thursday afternoon session, it replicates the name through to the NEXT Thursday morning. HOWEVER, I would like to also modify the colour of those fields, so that if the person on-call swaps with another person, instead of using the Formatter Painter and changing each group of cells, it does it automatically. Something like IF (E14 = "Bob", (CELL.Colour="Red",CELL.Text="Bob"), IF (E14 = "Fred", (CELL.Colour="Blue",CELL.Text="Fred"), (CELL.Colour="Green",CELL.Text=E14) ) I have set the above out as follows IF THEN ELSIF THEN ELSE Any ideas. Cheers Craig. |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
Change the colour of a bunch of cells, based on one cell.
Hi
see your other post -- Regards Frank Kabel Frankfurt, Germany Craig & Co. wrote: Hi, I have a montly on-call roster which is colour coded for each person on the roster. I have set it up that if you put a name in the Thursday afternoon session, it replicates the name through to the NEXT Thursday morning. HOWEVER, I would like to also modify the colour of those fields, so that if the person on-call swaps with another person, instead of using the Formatter Painter and changing each group of cells, it does it automatically. Something like IF (E14 = "Bob", (CELL.Colour="Red",CELL.Text="Bob"), IF (E14 = "Fred", (CELL.Colour="Blue",CELL.Text="Fred"), (CELL.Colour="Green",CELL.Text=E14) ) I have set the above out as follows IF THEN ELSIF THEN ELSE Any ideas. Cheers Craig. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CF to change colour in cell based on date? | Excel Discussion (Misc queries) | |||
how do i change cell text colour based on value in other cell | Excel Worksheet Functions | |||
If a cell is updated can several other cells change colour? | Excel Discussion (Misc queries) | |||
Change colour of cells depending on entry in one cell | Excel Worksheet Functions | |||
How do I set a colour to 4 cells based on the value of a cell | Excel Discussion (Misc queries) |