|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Formatting on cell values outside of a designated range based on category denoted in key
Hello,
I have 5 different categories of product, and there are "average" ranges each one is supposed to be in. I want to highlight the formula driven value if it ever ends up outside of its respective range. Maybe a nested if statement for formula within conditional formatting? I'm a bit hung up. Also, this is first post, so bear with me please! Thanks |
#2
|
||||
|
||||
Hi and welcome
please post a sample sheet ( click - go advanced - Manage attachments) with some data and expected results - Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
RE:
Hopefully this illustrates what I'm trying to achieve
thx |
#4
|
|||
|
|||
Maybe like the attached.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting a Range | Phil H | Excel | 3 | 02-17-2016 08:33 AM |
select a cluster of point from a range based on x and y values | sandcharles | Excel | 5 | 02-19-2015 06:15 AM |
Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
Conditional formatting question based on cell date | Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |