cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Formula to use Conditional Formatting to emphasise both the names of employees who were late. and

declan.commissionerforoaths
Copper Contributor

‎Dec 12 2017 06:04 AM - last edited on ‎Jul 25 2018 10:34 AM by

‎Dec 12 2017 06:04 AM - last edited on ‎Jul 25 2018 10:34 AM by

Formula to use Conditional Formatting to emphasise both the names of employees who were late. and

I am struggling to know what formula will allow me to highlight employees who are late.

 

Regards

 

Declan

Preview file
12 KB
695 Views
0 Likes
1 Reply
Reply
1 Reply
Sergei Baklan

‎Dec 12 2017 10:24 AM

‎Dec 12 2017 10:24 AM

Re: Formula to use Conditional Formatting to emphasise both the names of employees who were late. an

Hi,

 

If you mean to highlight their names apply the rule

=$E4="Late"

to your B columns (attached)

 

Preview file
14 KB
0 Likes
Reply