Hi,
Trying to get my head around custom data validation formulas.
My understanding is that the formula must return either a TRUE or FALSE answer?
Would appreciate if someone could clarify whether this understanding is accurate.
Hi,
Trying to get my head around custom data validation formulas.
My understanding is that the formula must return either a TRUE or FALSE answer?
Would appreciate if someone could clarify whether this understanding is accurate.
Thats about it. If a CF formula, applying to a particular cell returns TRUE, then the CF will be implemented in that cell.
so, =A1>3
will not apply formatting if A1 contains 1,2 or 3, but will if it contains 3 or more.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you.
Edit: contains MORE THAN 3. What an idiot I am.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks