Adapt code to include "number" and colour formatting

[dpcp]

Hi all,

I have a piece of code (with the help of forum member Marcol) that formats a column of cells based on the values in columns G and H. (see below)

I have to now add a numeric value to the coloured cells in column I, such that:
- when RGB(142,42,160) in I, value in cell = 4
- when RGB(0, 32, 96) in I, value in cell = 3
- when RGB(64, 224, 208) in I, value in cell = 2
- when RGB(255, 255, 255) in I, value in cell = 1

Please Login or Register  to view this content.

I'd be grateful if someone could help me adapt the above.

Many thanks!

DP

[snb]

If you analyse the code very carefully, it is very easy for you to adapt it with your new requirement.

While analysing you could simplify the code to:

Please Login or Register  to view this content.

[dpcp]

Hi snb

Thanks for your message!

I tried to use the simplified code you provided but unfortunately when I added further code to set the cell values, the values were not showing up in the column.

However, I did adapt my original code to the following:

Please Login or Register  to view this content.

And that works.

Many thanks for your help, otherwise I would not have had my 'brainwave' without it!

DP

[snb]

Please Login or Register  to view this content.

[dpcp]

Ah... I see... good point!

Many thanks again

DP