Forum Discussion
questions aboaut excel functions
Change the formula in D3 to
=IF(C3="";"";C3+14)
and that in E3 to
=IF(C3="";"";IF(TODAY()>=D3;"Finish Quarantine";"Quarantine"))
thank you for your answer
One more questioncan it be used in excel condittional formatting.?
how is the formula?
thank you
A conditional formatting formula must return TRUE or FALSE. For example:
=AND($C3<>"",TODAY()>=$D3)
A conditional formatting formula must return TRUE or FALSE. For example:Not quite.
In order to trigger the conditional formatting the formula must return TRUE or a number value not equal to 0.
If the formula returns text, an error value, 0 or FALSE the conditional formatting will not be triggered.
