conditional format between dates

[Kris75]

Hi Guys

<TABLE style="WIDTH: 243pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=324 x:str><COLGROUP><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" span=3 width=108><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: silver; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 height=17 width=108>Date Opened</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 81pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=108>First Attempt</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: silver; WIDTH: 81pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl25 width=108>Data Closed</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl26 height=17 width=108 x:num="40704.752569444441">10/06/2011 18:03</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.411539351851">13/06/2011 09:52</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver 0.5pt solid; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.411539351851">13/06/2011 09:52</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 height=17 width=108 x:num="40707.344930555555">13/06/2011 08:16</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.412280092591">13/06/2011 09:53</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.412280092591">13/06/2011 09:53</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 height=17 width=108 x:num="40707.362800925926">13/06/2011 08:42</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.413865740738">13/06/2011 09:55</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.44290509259">13/06/2011 10:37</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 height=17 width=108 x:num="40707.368078703701">13/06/2011 08:50</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.421493055554">13/06/2011 10:06</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.421493055554">13/06/2011 10:06</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 81pt; HEIGHT: 12.75pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 height=17 width=108 x:num="40707.379629629628">13/06/2011 09:06</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.42633101852">13/06/2011 10:13</TD><TD style="BORDER-BOTTOM: silver 0.5pt solid; BORDER-LEFT: silver; BACKGROUND-COLOR: transparent; WIDTH: 81pt; BORDER-TOP: silver; BORDER-RIGHT: silver 0.5pt solid" class=xl26 width=108 x:num="40707.42633101852">13/06/2011 10:13</TD></TR></TBODY></TABLE>

I need some help with conditional formatting - it should be easy but i can't seem to figure it out

I want to use conditional formatting to identify when a first attempt (col B) and/or Data Closed (Col C) occur when less than 24 hours has passed from Date Opened (Col A)

thanks

 

[cornflakegirl]

Try using Formula Is within conditional formatting, and setting it to:

=OR(B2-A2<=1,C2-A2<=1)

Then use the format painter to copy the formatting down.

 

[Kris75]

Works like a dream, thank you!