Conditionally format every individual cell in a selected range with multiple rules

Hi,

I am looking for a quick way to cond. format every cell in a given range with the following criteria:

If the cell contains a C, I, or A format it beige with black font and IF cell contains P, E , Cl, format it Black with white font colour.

The reason as to why i want to do this is to apply a macro later on to overwrite the conditional formatting with a manual format if the user desires. The macro will read: If there is a background colour on the cell, deactivate the conditional formatting.

The range i have selected in W8 to AH 100 and i am looking for a quick way to add the above format without clicking every cell and aplying those rules.

Thanks.

Hi,

When i put that formula into the format with formula option, it doesnt apply it to the cells that have those values...

Just to clear my question, i want to apply individual conditional formatting to every individual cell in that range... so that i can turn off/ delete the format for one cell via a macro if the user needs to format to different colour.