Change the colour of a bunch of cells, based on one cell.

  • Thread starter Thread starter Craig & Co.
  • Start date Start date
C

Craig & Co.

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.
 
Hi
for only 3 persons you could use 'Format - Conditional Format' for this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Colour a row, based on a cell value 8
Loop to copy paste rows base on table arrays 0
Adjusting height of text cells 3
Changing cell colours based on a cell value 1
Re. Conditional formating of adjacent cells but down a column 0
how can i change colour of a cell 2
Format colour of cells based on other cell - 34 colours 2
change current cell colour based on the value of adjacent cell on other worksheet 2

Back
Top