Hello All.

My question involves 2 cells. 1 (G45)which totals times input in various parts of the sheet and 2 which shows the time as a component of a process (L45)


In cell L45 I have 2 cfs - one which simply turns red if L45 > G45. No problem.


What the other cf does is warn the user when there is only 30mins (turns yellow) left to input before the cell turns red. L45>G45-0.020833333

In most cases this is fine because there is time in G45. However when G45 has no time in (0:00) then L45 shows yellow. Clearly because L45 is greater than G45.


What I am struggling to do is make L45 stay its normal colour while G45 shows no time.

I think I have reached the " cannot see the wood for the trees ! " with this.


My thanks in anticipation.