Timeline colour cells depending on data inputted in a different cell

[MRKadar]

I would like to colour blank cells depending on the date change in a different cell. Please see table below *** an example.

ACTIVITY​	START​	FINISH​		07-Jul-14​	14-Jul-14​	21-Jul-14​	28-Jul-14​	04-Aug-14​	11-Aug-14​
A​	29-May-14​	07-Aug-14​
B​	05-Jun-14​	22-Aug-14​
C​	30-Jun-14​	23-Sep-14​
D​	22-Jul-14​	04-Aug-14​
E​	08-Sep-14​	24-Oct-14​

<TBODY>
</TBODY>

 

[gaz_chops]

Very strange, it appears as you want on mine!
Can you post screen shot of conditional format rule.

 

[MRKadar]

I only starteed using mrexcel last week. I cant attach anything, please advise how you share screen shots?

 

[MRKadar]

ACTIVITY

START

FINISH

07-Jul-14

14-Jul-14

21-Jul-14

28-Jul-14

04-Aug-14

11-Aug-14

18-Aug-14

25-Aug-14

01-Sep-14

08-Sep-14

15-Sep-14

22-Sep-14

29-Sep-14

A

28-Jul-14

29-Sep-14

B

07-Jul-14

22-Sep-14

C

25-Aug-14

21-Sep-14

D

21-Jul-14

04-Aug-14

E

08-Sep-14

29-Oct-14

<COLGROUP><COL style="WIDTH: 54pt" width=72><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2400" span=2 width=75><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2400" width=75><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216" width=38><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088" width=34><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1216" width=38><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088" span=10 width=34><TBODY>
</TBODY>