Pau Lo
asked on
if formula with colour based formatting
I need assistance with a formula which if a score is 1-4 (e.g. 1, 2, 3 or 4), the cell is formatted clear background with "minor" as the text, if score is 5-6 (e.g. 5 or 6) the cell is formatted "low" with green background, if score is 7-10 (e.g. 7, 8, 9 or 10) the cell is formatted colour yellow with "moderate" as the text, if the score is 11-15 (e.g. 11, 12, 13, 14 or 15) the cell is formatted colour orange with "significant" as the text", and if the score is 16-24, the cell is formatted colour red with "critical" as the text. Can this be easily achieved?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Roy Cox
Here's a good explanation for VLOOKUP closest match
ASKER
Example would be good
I'll put one together for you. It might be in the morning as I'm about to finish for today.
I've found one that created previously.
VLOOKUP.xlsx
VLOOKUP.xlsx
Some feedback from pma111 would be appreciated.
Pleased to help