View Single Post
 
Old 05-01-2021, 11:30 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
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

Yes you can, easily, but in tables you need to use indirect references
2021-05-01_192010.png
with a formula:
2021-05-01_192542.png
but this is very basic conditional formatting and based on guesswork.
Best to attach a workbook with both sheets and we can add working conditional formatting which will cover more columns of highlighting.
Reply With Quote