"IF" statement & "strikethrough" formatting

J

jijy

I am working on an excel spreadsheet that has employee data. Th
employees who are inactive/retired are identified using th
"strikethrough" formatting. Now what I want to do is to enter an "IF
statement to say if cell A1 has "strikethrough" formatting
say"Inactive" else say "active". Is there a way this can be achieved?

Thanks

Jij
 
B

Biff

Hi!

See this:

http://tinyurl.com/coceb

If you use the worksheet formula method you can use a formula like this:

=IF(Strike,"Inactive","Active")

Read the entire thread. Formatting does not trigger a calculation.

Biff
 
Top