Conditional formatting dates

[alan.sluder]

Needing similar help.. In my worksheet trying to the following
=IF(ISNUMBER($L8),L8-TODAY(),"")>0 green background with white font
=IF(ISNUMBER($L8),L8-TODAY(),"")=0 yellow background with black font
=IF(ISNUMBER($L8),L8-TODAY(),"")<0 red background with white font
if cell is blank then no color fill

I have a the formula =IF(ISBLANK(K8),"",K8+7) in L8 to show blank if nothing entered into K8. When K8 is blank currently filling with green. Guessing since there a formula in L8 reason getting the color fil. I have tried checking K for no values to do the no color but this doesn't work either.

 

[JoePublic]

CF will ignore formula errors so you can simply use:

=(L8-TODAY())>0 - green background with white font
=(L8-TODAY())=0 - yellow background with black font
=(L8-TODAY())<0 - red background with white font