HELP! conditional formatting to 1 cell with numerious entries!

Closed
Report
Posts
1
Registration date
Tuesday September 22, 2015
Status
Member
Last seen
September 22, 2015
-
Posts
2
Registration date
Wednesday September 23, 2015
Status
Member
Last seen
September 23, 2015
-
I am having some difficulty trying to apply conditional formatting to 1 cell with numerious rules - as i have found 1 rule will always work as new rules i create are in conflict which. I am basically trying to highlight project numbers to a key i have created i.e Reserved projects would be in yellow and Exchanged projects in Green so on so fourth.

So the issue im having would be in cell B2 from (Jun-14) i want to say for our London projects (A2) we have.. project 12(YELLOW), 14(RED) -- so what i want is to input data into the same cell but for them to be colour coordinated so it is easy to identify where we are with our current projects for sales meeting etc.


Can someone please help me!

2 replies

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
AHUNDAL, Good morning.

For me, it's dificult to understand your question.

Maybe you can save an example of your file at a free site, www.speedyshare.com and put a link to download here.

Remember to show the data you have and the result you want.
A real example helps a lot this understanding for all.
Posts
2
Registration date
Wednesday September 23, 2015
Status
Member
Last seen
September 23, 2015

Hi Ahundal,

Give me some sample data to help you with this immediately.