Thread: [Solved] The same Conditional Formatting works in one worksheet but not another
View Single Post
 
Old 04-03-2022, 11:27 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Hi
seeing the real sheet ( not a picture) would be a great help.
Be aware that formatting dos not change underlying values, it is just the way XL shows things to the outside world.
This being said be also aware that in a comparison, text is ALWAYS larger than any number. If you can provide the sheet, I will explain why. and text is always left aligned in a cell when no manual alignment has been applied even if it looks like a number)
__________________
Using O365 v2503 - 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
Reply With Quote