"IF" statement & "strikethrough" formatting

  • Thread starter Thread starter jijy
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionally formatting numeric data and text differently 1
Formatting the color of a range of cells based on the value of one cell 3
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Conditional Formating Based on Formats Instead of Values 1
Finding and deleting text in strikethrough 2
IF Strikethrough 8
Comparing formatting of two cells 3
Hyperlink function in an If function 3

Back
Top