conditional formatting on formula

[srizki]

I have =IF(D29<>"",DATEDIF(D29,TODAY(),"d"),"") in column C.
This give me the number of days from a date in column D, I want to highlight the numbers that are over, say, 25 days. If I use conditional format and use the cell value is, "Greater than or equal to", that works fine only where there are numbers, but where thare are no numbers, (empty cells with formula in it) it highlights all the cells.
I need a correct formula.

Regards

 

[VoG]

You would need to use the Formula Is option and the formula

=AND(C1<>"",C1>25)

 

[srizki]

Thank you very much VoG


this formula works exactly as I wanted.

 

[T. Valko]

I have =IF(D29<>"",DATEDIF(D29,TODAY(),"d"),"") in column C.
This give me the number of days from a date in column D, I want to highlight the numbers that are over, say, 25 days. If I use conditional format and use the cell value is, "Greater than or equal to", that works fine only where there are numbers, but where thare are no numbers, (empty cells with formula in it) it highlights all the cells.
I need a correct formula.

Regards

Use the "Formula Is" option and use a formula like this:

=N(A1)>25

 

[srizki]

Thank you Valco,

 

[T. Valko]

Thank you Valco,

You're welcome!