chriskenny
New Member
- Joined
- Jun 4, 2019
- Messages
- 21
I have a conditional rule in cell I2 if less than 02:00 and want to know how I would apply the rule so it colours the whole row from A2 through to K2
Thank you
Thank you
A | B | C | D | E | F | G | H | I | J | K |
Contractor Id | Contractor Name | Contractor Organization | Company Visiting | Date | Signed In | Signed Out | Total Hours spent | Contract Hrs | Difference | Action |
1009 | Francene Foote-Douglas | Astum | Tony Gee And Partners LLP | 28/06/2019 | 17:32 | 19:51 | 2.19 | 2.00 | 0.19 | Signed Out |
I have a conditional rule in cell I2 if less than 02:00 and want to know how I would apply the rule so it colours the whole row from A2 through to K2
I have a rule in H3 if <2