sheriffwoody
Distinguished Member
- Joined
- Oct 7, 2010
- Messages
- 8,091
- Reaction score
- 1,747
- Points
- 1,634
- Age
- 39
having read a few of the replys to help another member with an excel problem i thought i would share my issue.
i need to put some conditional formatting into a spreadsheet, but haven't really used it before.
column a is budget column
column b is actual spend/income column
column c is a variance column (between B and A)
what i need are the cells in column c to turn red if the variance is either £500,000 OR 5% adverse to plan.
this is in old excel by the way (2003 version)
any ideas?
i need to put some conditional formatting into a spreadsheet, but haven't really used it before.
column a is budget column
column b is actual spend/income column
column c is a variance column (between B and A)
what i need are the cells in column c to turn red if the variance is either £500,000 OR 5% adverse to plan.
this is in old excel by the way (2003 version)
any ideas?