questions aboaut excel functions

[taroda385]

[#2]

@taroda385 

Change the formula in D3 to

=IF(C3="";"";C3+14)

and that in E3 to

=IF(C3="";"";IF(TODAY()>=D3;"Finish Quarantine";"Quarantine"))

[#3]

@Hans Vogelaar 

thank you for your answer

One more questioncan it be used in excel condittional formatting.?

how is the formula?

thank you

[#4]

@taroda385 

A conditional formatting formula must return TRUE or FALSE. For example:

=AND($C3<>"",TODAY()>=$D3)

[#5]

@Hans Vogelaar

Thank You very much

[#6]

@Hans Vogelaar 

---

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.

[#7]

@taroda385 

It looks like two parallel discussions about the same, another one https://techcommunity.microsoft.com/t5/excel/excel-formula-questions/m-p/1659387

[#8]

@Detlef Lewin 

thanks for helping me solve this formula function problem

I have tried and succeeded in conditional formatting

[#9]

@Sergei Baklan 

Sorry, Sir
double posting error occurred