Conditional formatting

[D_N_L]

Hi all,

I have attached an example workbook. Sheet 1 shows how my data is now and Sheet 2 shows how I would like conditional formatting to be applied (basically applying a colour to cells that have identical text).

Any ideas?

[timbo1957]

Try this it has the cells in columns C formatted to blue and then three conditional formats type in a name and they will change colour.

[Fotis1991]

Hi

You can use three conditions in conditional formating.

So you put pne standart colour and three conditional.

See the attachement

Hopr to helps you.