hi, I want to add multiple condition for conditional format, example column "A" has number and text and i want to highlight the cell which has only numbers but the number should be greater than zero. please help me to clear this issue. many thanks in advance.
BR
Cool Sab
You can use AND and OR, just as you can in normal formulae, to mix and match multiple conditions.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Its not working i use the formula
Please Login or Register to view this content.
Not quote:
=AND(ISNUMBER(A1);A1>0)
Still it is not working...! Please see the attached excel error image for your reference.
ERROR.png
=AND(ISNUMBER(A1);A1>0)
change the above as ,
like
=AND(ISNUMBER(A1),A1>0)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Please see attached:
Thank you so much, it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks