Link to home
Start Free TrialLog in
Avatar of lancegallagher_expertsexchange
lancegallagher_expertsexchange

asked on

Excel 2003 conditional formatting

Hello experts, I need a hand with formula based conditional formatting. I need to colour the cells in two columns where there is a difference against a target value. This target value is held in one of the cells and is changed weekly.

I've attached a sample spreadsheet which hopefully illustrates my question

Thanks for any help or suggestions
RAG-Example.xls
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

I don't follow your logic. If the percentage is greater than target it should be green but if more then 10% greater than target it should be orange, and if more than 20% greater it should be red? But that does not match your applied formatting as far as I can see.
"more than 10%" rather than "more then". :)
Following your rules, the final result will not be like you posted on your file!

If value in Actual Number is greater than or equal to Target Number
If value in Actual Number is 10% or less than Target Number
If value in Actual Percentage is 20% or greater than Target Percentage - do you meant "Target Number"?

jppinto
RAG-Example-1-.xls
I think the line:

If value in Actual Percentage is greater than or equal to Target Percentage

should read:

If value in Actual Percentage is lees than or equal to Target Percentage
If value in Actual Percentage is less than or equal to Target Percentage
ASKER CERTIFIED SOLUTION
Avatar of gtgloner
gtgloner
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lancegallagher_expertsexchange
lancegallagher_expertsexchange

ASKER

Thanks very much,
You're welcome, thanks for the grade, hope to be helpful to you in the future.

Glenn