Conditional formatting ignoring Maximum value

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional formatting ignoring Maximum value

FAQ

Thread Tools

Display Modes

10-13-2023, 04:48 PM

p45cal

Windows 10 Conditional formatting ignoring Maximum value

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

All numbers 180 and above will be the same colour, as will all numbers 0 and below. (Test it by filtering on cell colour.) Isn't this to be expected?
How do you want numbers above 180 to be formatted?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting	Joanne	Excel	8	01-28-2019 08:30 AM
Conditional formatting	bbutl027	Excel	15	12-05-2016 08:56 PM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	teza2k06	Excel	3	01-19-2014 02:34 AM
conditional formatting	otuatail	Excel	1	06-06-2012 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 AM.