Thank you, but I did try these but it did not format across the whole sheet and in places I should not have.
For some reason I cannot attach screen shots, so I have done my best to show rule
[TABLE="width: 854"]
<colgroup><col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="160" style="width: 120pt; mso-width-source: userset; mso-width-alt: 5851;"> <col width="157" style="width: 118pt; mso-width-source: userset; mso-width-alt: 5741;"> <col width="174" style="width: 131pt; mso-width-source: userset; mso-width-alt: 6363;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="116" style="width: 87pt; mso-width-source: userset; mso-width-alt: 4242;"> <col width="82" style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <tbody>[TR]
[TD="width: 87, bgcolor: transparent"]A
[/TD]
[TD="width: 160, bgcolor: transparent"]B
[/TD]
[TD="width: 157, bgcolor: transparent"]C
[/TD]
[TD="width: 174, bgcolor: transparent"]D
[/TD]
[TD="width: 75, bgcolor: transparent"]E
[/TD]
[TD="width: 64, bgcolor: transparent"]F
[/TD]
[TD="width: 75, bgcolor: transparent"]G
[/TD]
[TD="width: 116, bgcolor: transparent"]H
[/TD]
[TD="width: 82, bgcolor: transparent"]I
[/TD]
[TD="width: 73, bgcolor: transparent"]J
[/TD]
[TD="width: 75, bgcolor: transparent"]K
[/TD]
[/TR]
[TR]
[TD="width: 87, bgcolor: transparent"]Contractor Id
[/TD]
[TD="width: 160, bgcolor: transparent"]Contractor Name[/TD]
[TD="width: 157, bgcolor: transparent"]Contractor Organization[/TD]
[TD="width: 174, bgcolor: transparent"]Company Visiting[/TD]
[TD="width: 75, bgcolor: transparent"]Date[/TD]
[TD="width: 64, bgcolor: transparent"]Signed In[/TD]
[TD="width: 75, bgcolor: transparent"]Signed Out[/TD]
[TD="width: 116, bgcolor: transparent"]Total Hours spent[/TD]
[TD="width: 82, bgcolor: transparent"]Contract Hrs[/TD]
[TD="width: 73, bgcolor: transparent"]Difference[/TD]
[TD="width: 75, bgcolor: transparent"]Action[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1009[/TD]
[TD="bgcolor: transparent"]Francene Foote-Douglas[/TD]
[TD="bgcolor: transparent"]Astum[/TD]
[TD="bgcolor: transparent"]Tony Gee And Partners LLP[/TD]
[TD="bgcolor: transparent"]28/06/2019[/TD]
[TD="bgcolor: transparent"]17:32[/TD]
[TD="bgcolor: transparent"]19:51[/TD]
[TD="bgcolor: transparent"]2.19[/TD]
[TD="bgcolor: transparent"]2.00[/TD]
[TD="bgcolor: transparent"]0.19 [/TD]
[TD="bgcolor: transparent"]Signed Out[/TD]
[/TR]
</tbody>[/TABLE]
I have a rule in H3 if <2 then it get highlighted in red and if >3 then highlighted in green
Thank you