I recently reverted to using excel 2003 coming from 2007 and I'm having an issue navigating the conditional formatting in this version. I need to apply a format across rows in a spreadsheet once the condition is met.
Scenario:
In column G, I have a list of numbers stating the current status of each department in my firm
Starting from column H:S are the monthly changes (if any)
In column T I have an average function.
What I wish to accomplish is to format the rows on the sheet based on the condition; if there is a change in column G & S.
Therefore the conditions should be:
1. If column S is greater than column G
2. If column S is less than column G.
Please assist, thanks.
Bookmarks