The problem i am getting here is that i am specifying it to format cells with value greater than 0.01 but it is still formatting blank cells (because they contain a formula). Please help!
The problem i am getting here is that i am specifying it to format cells with value greater than 0.01 but it is still formatting blank cells (because they contain a formula). Please help!
Try using a formula in conditional formatting to format when > 0.01 and not blank, e.g. for A1
=AND(A1>0.01, A1<>"")
Audere est facere
Perfect! Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks