Conditional Formatting on cell values outside of a designated range based on category denoted in key

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting on cell values outside of a designated range based on category denoted in key

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-21-2018, 07:59 AM

interntime interntime is offline

Windows 7 32bit Conditional Formatting on cell values outside of a designated range based on category denoted in key

Office 2016

Novice

Join Date: May 2018

Posts: 3

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.