Conditional formatting is based on the outcome of the condition
evaluating to True. If the evaluation is True, then the specific color
you selected is applied. i believe if you want this color scheme then
you will need to use VBA to effect the rotating colors

Mr. Low wrote:

Hi,

I need to conditional format a table with 3 rotating colors of yellow, green
and blue. The condition to change the color is when the code changes.

Illustration:

A B C D
1 B12 XXX XXX Yellow
2 B12
3 C26 Green
4 C26
5 C26
6 D52 Blue
7 E27 Yellow
8 E27
9 E27
10 E27
11 G49 Green
12 G49
13 H96 Blue

There is a maximum of 3 formulas under conditional formating.

May I know what are the formulas 1, 2 and 3 in order for me to get the
result ?

Thanks

Low