Hi all, I have posted the quetion below on the Windows Excel discussion
group and I was suggested to post it in here with he spreadsheet.

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.

It was pointed out ot me that I can have only a maximum of 56 colour
for the clients. This will not be an issue as it will be very unlikely
that we are going to have live projects from more than 56 clients and
once a project is no longer live, then the colour referencing will be
removed.

Ideally I would like to be able to pick the colours for the clients to
be quite different so that visually it is easy to identify how many live
projects we have for each client.

Any help very much appreciated! Please note I have never done any VBA
programming before, but I believe that I will not be able to do this via
conditional formatting.

Thanks in advance


+-------------------------------------------------------------------+
|Filename: Quotes & Jobs Database Renata.xlsx |
|Download: http://www.thecodecage.com/attachment.php?attachmentid=10|
+-------------------------------------------------------------------+

--
Inglesina 94
------------------------------------------------------------------------
Inglesina 94's Profile: http://www.thecodecage.com/forumz/member.php?userid=25
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=28014