Help formatting Column based on values in another column.
 

Hey,

I'm trying to have a value in column M strikethrough if the value in the same row but column F does not contain "xxxx".

Example:

Column M has dates and Column F has a status of an order.
If the status of cell in column F, is not "approved", I want the date in Column M to strikethrough...

..... is that possible?

Thanks in advance.

Help formatting Column based on values in another column.
 

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