Gentlemens ... The Conditionnal Formatting applies only when I have no more than 3 conditions.
Here's my problem. The cells of the column G in my excel sheet may contain only 5 values: AA, BB, CC, DD, EE, FF.
Depending on the value recorded in my column G, I want the backcolor of the cell to change. For example, when the value is AA i want the backcolor to be Blue, For BB it will be green, for CC it will be yellow, for DD it will be the Orang, and for EE it will be the Brown.
I know I must go through the VBA, or I do not know how to do it and where to place the code.
Can you help me.
Thank you
Bookmarks