Conditional Formating of cells

[Closed]
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
Hello,
I am trying to set up the conditional formats of cells as follows :In column D place the company name - have the next 13 cells to the right to be coloured red. If I place a different company name in column have the next 13 cells to the right be a different colour. I have about 6 company names that I wish to format in this in this way. The company name may change from row to row - but I want the specific Company to always be the same colour. Eg Company 1 aways red - company 2 always blue etc.


1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Do you mean you want to enter the company name on, say, A1, and have B1:N1 colored red
Then enter another name in A1 and have O1:A1 change to green, but have B1:N1 still stay red?

If so, then you wont be able to do that with CF, you will need VBA for that.

If that was not what you meant, can you explain again please?