MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Coloring text (or background) depending on value in cell


Posted by Geoff on March 04, 2001 1:11 PM

If the cell value is greater than say 20 I want to highlight the cell in some way. Either by changing the font color, the cell background color or even the font style. Can I do this as a user defined function such as

function blue(b)
if b>20
fontcolor?????=blue????
else
fontcolor?????=green???
endif

If so what are the correct words. If not does anyone know a way of doing it?
Many thanks.
Geoff


Posted by Aladin Akyurek on March 04, 2001 1:42 PM

Would Conditional Formatting not do the job?

Posted by Roger Redhat on March 04, 2001 1:44 PM

Geoff,
Why don't you use Conditional Formatting?

Regards,
Roger.