Thread: Time Conditional Formatting
View Single Post
 
Old 03-09-2021, 08:10 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
to save you working out the 0.7916667 you can use:
=19/24
in the conditional formatting rule.
Attached Images
File Type: png 2021-03-09_151135.png (7.9 KB, 14 views)
Reply With Quote