Strikethrough is the default 'effect' in CF/Font. To enable it you must fill
out the empty selection fields.

Use this formula:
=NOT(Status="Approved")

...where "Status" is a named range with local (sheet level) scope, defined as
follows:

Select F1 and open the Define Name dialog;
Name: 'sheetnamehere!'Status
OR in newer versions:
Name: Status
Scope: name of sheet being used on
RefersTo: =$F1
Press Enter

This defined name will now work in any column to ref column F in the row using
this name. Giving it sheet level scope allows using it on other sheets
independantly without conflict.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion