Thank you for that..I am still a little confused.


In L2, =IF(COUNT(H2:I2)<2, "", I2/H2 - 1 --- I added this formula as a third condition (see below).

=IF(G2<I2, TRUE,FALSE) = Green
=IF(G2>I2, TRUE,FALSE) = Red
=IF(COUNT(H2:I2)<2), "", I2/H2 = Yellow - but it is not doing it

I was not sure where to input: =AND(COUNT(H2:I2)=2, H2<I2)?

Thanks!
JC