Text formatting and coloring - in-cell commands?

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
 
F

Frank Kabel

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Cells by Format 2
Changing cell colors from a function command 3
color coding values 0
Change text box background color depending on value in Label Reports 0
Formatting color and font to a logical statement result? 7
Cell Formatting 3
how to format cells -fill color 2
Conditional Formating in Blank Cells 4

Top