Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-16-2023, 08:21 AM
p45cal's Avatar
p45cal p45cal is offline Conditional formatting ignoring Maximum value Windows 10 Conditional formatting ignoring Maximum value Office 2021
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

See the CFs in range A1:A17 in the attached.
2023-10-16_162309.jpg
Not in the attached, you could do it with just 2 CFs:
2023-10-16_162811.jpg
One thing you may have forgotten to do when setting up the additional CFs is while setting the format, to actually click on the No Color button (so that the Clear button is no longer greyed out):
2023-10-16_163103.jpg
Attached Files
File Type: xlsx msofficeforums51495.xlsx (8.6 KB, 5 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting ignoring Maximum value Conditional Formatting Joanne Excel 8 01-28-2019 08:30 AM
Conditional formatting ignoring Maximum value Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
Conditional formatting ignoring Maximum value 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 09:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft