Fomula to check formating of a cell.

  • Thread starter Thread starter charlesg100
  • Start date Start date
C

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.
 
Back
Top