Conditional Formatting - creating rules based on colours in cell list

Please attach your sample as a workbook, not a screen capture that most users can't see, also remember, you can't test conditional formatting / formulas on a screen capture.

Attached, thanks

Conditional formatting question.xlsx



It is just a simple file at the moment with 4 rules

Cell Value contains 'Fisher' which turns font blue
Cell Value contains 'Ellis' which turns fill purple
Cell Value contains 'Johnson' which turns fill yellow
Cell Value contains 'Jones' which turns fill green and font white

Try this, it will write all of the rules for you.

Note that it's written to pick up 'proper' formats from the source range, so it will not recognise existing conditional formats there.

There are 2 ranges set at the start of the code, rng tells the code where the sample formats should be copied from, rng2 tells it where they should be applied, change these to suit.

Please Login or Register  to view this content.

Absolutely magnificent piece of excel knowledge.

Thanks very very much Jason.b