Excel: Format entire row ??

I need to conditionally format all font in an entire row across the whole spreedsheet. This is based off a single cell for each row that will contain several different possible entries. the font should stay red when any data other than a date is entered and change to black when a date is entered. This is to indicate visually a complete (when date is entered) and pending when any other value is entered.

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of December 22, 2015.

For more resources for Microsoft Excel