software

I am working on an excel spreadsheet that has employee data. The
employees who are inactive/retired are identified using the
quot;strikethroughquot; formatting. Now what I want to do is to enter an quot;IFquot;
statement to say if cell A1 has quot;strikethroughquot; formatting,
sayquot;Inactivequot; else say quot;activequot;. Is there a way this can be achieved?

Thanks

Jijy--
jijy
------------------------------------------------------------------------
jijy's Profile: www.excelforum.com/member.php...oamp;userid=15042
View this thread: www.excelforum.com/showthread...hreadid=524484Hi!

See this:

tinyurl.com/coceb

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

=IF(Strike,quot;Inactivequot;,quot;Activequot;)

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

Biff

quot;jijyquot; gt; wrote in message
...
gt;
gt; I am working on an excel spreadsheet that has employee data. The
gt; employees who are inactive/retired are identified using the
gt; quot;strikethroughquot; formatting. Now what I want to do is to enter an quot;IFquot;
gt; statement to say if cell A1 has quot;strikethroughquot; formatting,
gt; sayquot;Inactivequot; else say quot;activequot;. Is there a way this can be achieved?
gt;
gt; Thanks
gt;
gt; Jijy
gt;
gt;
gt; --
gt; jijy
gt; ------------------------------------------------------------------------
gt; jijy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15042
gt; View this thread: www.excelforum.com/showthread...hreadid=524484
gt;

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

Thanks a lot.

Cheers,

Jijy--
jijy
------------------------------------------------------------------------
jijy's Profile: www.excelforum.com/member.php...oamp;userid=15042
View this thread: www.excelforum.com/showthread...hreadid=524484You're welcome!

Biff

quot;jijyquot; gt; wrote in message
...
gt;
gt; Thanks Biff for the code. It works for me now.
gt;
gt; Thanks a lot.
gt;
gt; Cheers,
gt;
gt; Jijy
gt;
gt;
gt; --
gt; jijy
gt; ------------------------------------------------------------------------
gt; jijy's Profile:
gt; www.excelforum.com/member.php...oamp;userid=15042
gt; View this thread: www.excelforum.com/showthread...hreadid=524484
gt;