Thread: [Solved] Conditional formatting ignoring Maximum value
View Single Post
 
Old 10-13-2023, 04:48 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 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
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?
Reply With Quote