Test on the format of a cell in a formula ?
 

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)

Test on the format of a cell in a formula ?
 

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

http://www.nicholasperkins.com/blog/

"brunzeg" wrote:

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)