|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
05-21-2018, 07:59 AM
|
|||
|
|||
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
05-21-2018, 08:22 AM
|
||||
|
||||
|
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
05-21-2018, 08:36 AM
|
|||
|
|||
|
RE:
Hopefully this illustrates what I'm trying to achieve
thx
|
|
|
|
|
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 |
Windows 7 32bit 
Office 2016
Linear Mode
