If any formula is available to set the cell for some timings for example <TABLE style="WIDTH: 71pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=94 border=0><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 id=td_post_2904531 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 71pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #ffc000" align=right width=94 height=20>7:15 PM</TD></TR></TBODY></TABLE> so the second the particulars time reaches , some kind of a high light or pop up can come , so that , we can get the attention on this as to see what is it . I request to help me what formula to be used .
Let's say you want to highlight cell A1 if it contains a time that is less than the current (system) time.
Select the relevant cell.
Go into Conditional Formating.
Use a formula to determine which cells to format
Use this formula
and format as required.
Copy to other cells if you like.
I tried doing this , but I'm not getting thru , may be I have not understood this properly . I have my doubt as the formula should be something else as the formula cannot be simply " =A1" , it should have something more , pls let me know if i'm not wrong .