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

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

Thanks for any help or suggestions

RAG-Example.xls

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

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 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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks very much,

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

Glenn

Glenn