excel conditional formatting AND isnumber

Posted on

QUESTION :

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:

=INDIRECT(ADDRESS(ROW(),COLUMN()-1))>INDIRECT(ADDRESS(ROW(),COLUMN())) AND ISNUMBER(INDIRECT(ADDRESS(ROW(),COLUMN()-1)))

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

ANSWER :

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:

=AND(INDIRECT(ADDRESS(ROW(),COLUMN()-1))>INDIRECT(ADDRESS(ROW(),COLUMN())),ISNUMBER(INDIRECT(ADDRESS(ROW(),COLUMN()-1))))

Leave a Reply

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