Forum Discussion
EXCELL Conditional formatging
Please provide more detailed information - which columns contain what?
Preferably insert a screenshot and/or attach a sample workbook without sensitive info.
this is my report and were monitoring who left the job site early and not just back and forth between job sites... so we want the last time out instead of all the times in between and I pull this report from our badging system..
- I have highlighted the time out column and if you look in column c you can see the duplicated last names which tells me how many times they went in and out but I only want the last one...
Thanks.
Select I3 and down, as far as needed.
I3 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=AND(I3<>"". I3<TIME(17,20,0))
Click Format...
Activate the Fill tab.
Select light red as fill color.
Click OK, then click OK again.Repeat, but with the formula
=AND(I3<>"", I3<TIME(16,0,0))
and light green as fill color.
Finally, repeat the steps with formula
=AND(I3<>"", I3<TIME(14,0,0)
and amber as fill color.
