Conditional formatting ... or VBA programming help

[Inglesina 94]

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|
+-------------------------------------------------------------------+

 

[Simon Lloyd]

Welcome to our forums!, what do you want to happen if the job is on
hold?


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)

 

[Simon Lloyd]

I am looking at this but its a really big ask

--
Simon Lloy

Regards
Simon Lloy
'www.thecodecage.com' (http://www.thecodecage.com

 

[Inglesina 94]

I am looking at this but its a really big ask!

Thanks emb1 did not realise it was going to be complex ... is ther
anyway you can give me some pointers and I can then work it out b
myself??

if on hold, I would like the row to retain the relevant client colou
but the text to be changed to italic, not bold

 

[Inglesina 94]

I am looking at this but its a really big ask!

Simon,

I was wondering if you had a chance to look at this further?

Inglesina94

 

[Don Guillett]

I could not see your file but you should be able to do this using SELECT
CASE. Look in the vba help index. send your file to my address below if you
would like me to look. Be VERY specific as to what you want and provide
examples.