Previous Topic Next Topic

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 response

Answer 1 / 1
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?

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Excel function question
1234ah -
ac3mark -

3 responses