Test on the format of a cell in a formula ?

[brunzeg]

I want to test on the format of a cell in my formula. Example : If the police
font of the cell(A4) is strikethrough then ...
Other example : If the cell color of the cell A4 is red then ...

=IF(????=[red??];true;false)

 

[Nicholas Perkins]

Hi Brunzeg,

This would require the use of a user-defined function. I'm happy to help you
with this.

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Cheers,
Nicholas Perkins
(e-mail address removed)
http://www.nicholasperkins.com/blog/