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.

Hi and welcome
perhaps something like = AND(G45>0,L45>G45) for the red cf
Whenever G45is null, nothing will happen
Also check the " Stop If true" checkbox

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hello Pecoflyer - thank you for the welcome...

and thank you for the resolve to my question - it works a treat !

I had just hit the buffers on that one !
Thanks again.