Fomula to check formating of a cell.

[charlesg100]

Good day all,

I am looking for a formula (or rather an addition to an
existing 'IF' formula) to check the formating of a cell,
in particular the color, then decide to on whether to
return the solution?

A sample of the formula is:

=IF(VLOOKUP(168,'Schedule.xls'!ASSN,1,FALSE),"P","")

This one would then look at the formating of another cell
to make the final determination of whether to print
the "P" or not.

 

[Frank Kabel]

Hi
can be done only with VBA (checking the format). See for an example
(checking colors):
http://www.cpearson.com/excel/colors.htm