Conditional Formatting with Time

[taylorbenjamin8]

So glad I found this messageboard. I can't wait to browse and learn some new tips. My first question concerns conditional formatting. I have a column which displays time in the format of [H]:MM. No problems there. I would like to add a check mark to any cell in the column that is equal to or greater than 3:00. For the love of me I can't figure out how to apply conditional formatting to time formats. In a perfect world, the check mark would apply to the column adjacent to the column with the time value. I.E. if the time in k3 >= 3:00 then a check mark would appear in L3. At this point however, if I could get it to appear in any box I'll be happy.

 

[shg]

In L3, =if(k3 >= --"3:00", "a", "") and set the font to Marlett.

 

[taylorbenjamin8]

That's perfect. Thanks a ton!

 

[shg]

You're welcome, glad it helped.