Thread: [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
View Single Post
 
Old 11-01-2018, 03:53 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 866
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
Quote:
Originally Posted by Marcia View Post
There will be a conditional formatting that will turn all the typed remarks except the remarks for absences ("X", "X X")into white font color, before printing the form, something that I learned how to do. The printed form will show only the Xes and the shades for late and cutting classes.
I'd be interested to know how you do this!


Quote:
Originally Posted by Marcia View Post
Is there a better way to shorten the very long formula in E21 to AI21?
I will look at this after we know for sure the sort of things that will appear in the cells above that formula. In the meantime, what version of Excel are you using? There are some newer functions which could simplify the formula a lot.
Reply With Quote