"IF" statement & "strikethrough" formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jijy - 20 Mar 2006 19:08 GMT

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

Reply to this Message

Biff - 20 Mar 2006 20:33 GMT

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

> I am working on an excel spreadsheet that has employee data. The
> employees who are inactive/retired are identified using the
[quoted text clipped - 5 lines]
>
> Jijy

Reply to this Message

jijy - 22 Mar 2006 17:54 GMT

Thanks Biff for the code. It works for me now.

Thanks a lot.

Cheers,

Jij

Reply to this Message

Biff - 22 Mar 2006 19:56 GMT

You're welcome!

Biff

> Thanks Biff for the code. It works for me now.
>
[quoted text clipped - 3 lines]
>
> Jijy

Reply to this Message