Excel Conditional Formatting and Isnumber
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...
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
2 Answers
Based on your above screenshot you can do this
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))))
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
