Text formatting and coloring - in-cell commands?

  • Thread starter Thread starter data_gnome
  • Start date Start date
D

data_gnome

Hello all.
I have a small chart that tracks a date range for expired time.
When the calculated value exceeds 30 (days) a notice shows to updat
the value, otherwise OK.

=IF(INT(B1-C3>=30),"CHANGE","OK")

I'd like to know what syntax and values I can use in the formula t
affect tect color and if possible bold, for example to make "OK" green
and "CHANGE" red. I can't use the conditional formatting for thi
because the spreadsheet will be used across several versions of Exce
(at least 97 and 95).

Thanks
Al Davi
 
Hi
you can't affect formats in formulas. So conditional format is the only
way to go (besides using an event procedure). But conditional format
works at least starting with Excel 97 (don't know about Excel 95
though)
 
Back
Top