Formatting for the whole worksheet

[Inglesina94]

Hi all, I'm stuck and need some help.

I have a worksheet that we use to track our clients and the progress of the
jobs, with one job per row.

Column B represent the job status (In Progress, On Hold, Completed ... 5
options in total). Column C represent the client with a 3 letter code.

I would like to:
- Change the colour of the row in relation to the client code - each client
will be associated a colour (I will then amend the formula to add new
clients/colours as new ones are added)
- Maintain the background colour and change the text to bold if the value in
cell B for that row is In Progress.
- Maintain the background colour and change the text to italic (not bold) if
the value in cell B for that row is On hold.
- Delete the background colour of the row if the value in cell B for that
row is one of 2 options - Stopped or completed

In practice, I would like all the rows of live projects to be coloured in
relation to their relevant client colour with the projects in progress is
bold or in italic if the job is on hold. Once the jobs are completed or
stopped, all conditional formatting to be removed.

I would like all of this to happen automatically as changes are made to the
worksheet, either within existing cell or when new projects are added.

Any help very much appreciated!

Re.

 

[Inglesina94]

Thanks for pointing this out to me as I did not realise there was a maximum
of 50 colours ... though I do not think this will be an issue as it is very
very unlikely we are going to have live projects with more than 540 different
clients and once the projects are completed the colour differentiation is
irrelevant.