[Solved] Conditional Formatting Gantt Chart

[jack22]

I am using open office 4.1.3 and trying to replicate this conditional format from excel =AND(E$5>=$B7,E$5<=$C7) into open office I have tried multiple way to get it work but I cannot. I am recreating this gantt chart https://www.youtube.com/watch?v=un8j6Qq ... vR&index=3 to fill a solid color the cell corresponding to the start and finish date of the project.
Any ideas would be much appreciated

Thank you.
Jack

[gerard24]

Using formula =AND(E$5>=$B7,E$5<=$C7) with mixed references (relative row or column), you need to have the good cell having focus when selecting the range for CF.
When selecting a range, lets says E7:Z15, if you start selecting from E7 to Z15 :
In Excel E7 have focus,
In OpenOffice Z15 have focus.

So you have two options :
Modify reference in the formula according to focused cell,
or (easier) select from Z15 to E7 (this way E7 have focus).

[jack22]

Thank you that's solved the problem.

Jack