I would like to use an IF formula in Excel for two cells where the one with the greater value is filled green and the less is filled red.
I know how to do =IF(A1<A2,?,?)
But I don't know what command to use to fill the cells a particular colour (where the question marks are).
Help please?
I know how to do =IF(A1<A2,?,?)
But I don't know what command to use to fill the cells a particular colour (where the question marks are).
Help please?