excel conditional formatting AND isnumber

Posted on


I’m trying to get my format sentence to work, but it just won’t

I want to format the cell green if the cell is greater than the cell before it (and that cell contains a number)

I’m trying:


I added the and because some cells with text next before them got red. It works without the AND ISNumber part

enter image description here


Based on your above screenshot you can do this

enter image description here

You simply use AND in wrong way – arguments should be listed separated by commas:


Leave a Reply

Your email address will not be published. Required fields are marked *