I have a spreadsheet that contains a number of columns and cells. I wish to make on of the cells subject to a conditional format. If the value of AA2 is greater than the value of E2 then make F2 Green, if it less make it red and if it equals do nothing.
I know this is a simple task but I can't for the life of me work out how to do more than one conditional format to a cell.
And I have ordered a dummies guide to Excel & VBA for those of you who are tired of answering my questions :)