Conditional Formating of cells

Closed
Spike - Aug 14, 2016 at 10:10 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 15, 2016 at 12:57 AM
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

fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 1
Aug 15, 2016 at 12:57 AM
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?
0