I have a spreadsheet where column K is the number of hours it takes for my crop to mature, column L is the date/time I planted the crop, column M is the addition of the two columns. This is so that I will know what day/time the crop will be ready to harvest.

What I want is to conditional format the harvest time (column M) so that when it is equal to or greater than real time it will bold type. This will alert me to harvest the ready crops.

---

Answer from Richard Rost:

In Excel 2000 you can't format with conditional formatting based on a date being greater than or less than another date (or the current time). What you COULD do, however, would be to make another column that has a TRUE or FALSE value in it, which could be whether or not the crop is ready:

=M1<=TODAY()

Now that value will be TRUE if the crop is ready, and FALSE otherwise. So just apply the conditional formatting to this column and make it as bright red as you want. :)