Conditional Formatting

[gtd526]

Hello,
Im using the following formula in Column "AP": =IF(LEN($AM4)>1,$T4,"")
Using Conditional Formatting(cell value >0) in Column "AP" to highlight cells, it highlights blank cells also.
How do I get around this in Conditional Formatting?

 

[Joe4]

Not sure why that wouldn't work, but maybe try using a Conditional Formatting formula instead, i.e.

=AND($AP4>0,$AP4<>"")

 

[gtd526]

Not sure why that wouldn't work, but maybe try using a Conditional Formatting formula instead, i.e.

=AND($AP4>0,$AP4<>"")

Yes. It works.
Thank you.

 

[Joe4]

You are welcome.