Please describe as to what is the condition of coloring a cell. anyways
conditional formating can be done for 3 colors (conditions), besides the
default color (normally white)
--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Mr. Low" wrote:

Hello,

I have the following table:

A B C
1 Y12 XXXX XXXX - Yellow
2 Y12
3 T24 - Green
4 T24
5 T24
6 H85 - Pink
7 H85
8 J74 - Yellow
9 M41 - Green
10 M41
11 M41

Is there anyway for me to condition format the table as illustrated? The
block need to change color only when refrence in column A channges. How
should the formula be ? If 3 colors are not possible what about two ?

Thanks

Low




--
A36B58K641