Conditional Formatting - sensing font to highlight condition

[Howard]

I have a spreadsheet date formatted cell(s). I would like to have
users apply a bold font (or some other formatting change)to that cell
to indicate if the date has been met. Can I use conditional
formatting to sense that change in condition, and use it to drive
conditonal formatting in another cell through some more conventional
application?

A traditional way might be to track start and complete dates, and
compare the two. However, I am looking for techniques to condense the
spreadsheet.

 

[Dave Peterson]

Maybe you could have the user put something in a column in the same row (an X in
column A???). Then use that in your format|conditional formatting rule:

Formula is:
=$a##="x"

or

Formula is:
=$a##<>""

Where ## is the number of the row with the activecell.