Hi,
I'd appreciate some advise on a formula to conditionally
format all records on my sheet (i.e. data in rows)when
this senario occurs:
1) When there is a date in Column AC for that row, and
2) When there is a N (for no)in AD for that row.
Also, there must be a date in AE for that row if Y (for
yes)is in AD.
I would like to apply the formula to the entire sheet to
get the effect of a 'dim out'when record is considered
complete.
Expert advise is appreciated as there are way too many
records to manually check for compliance and be certain of
future mass data input.