format color without conditoinal formating

W

WT

Is there any way to change a background color or font color in a formula,
without using conditional formating. I am currently using a 2003 version and
Conditional formating is limited.
 
G

Gary''s Student

You can use an Event macro that can adjust the background color depending
upon the cell's value.
 

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

Excel VBA 1
Reg. Change of font color in a cell 1
auto fill color of row 4
Formating cell by Comparing two cells for value 2
Conditional Formating 1
Comparing data sets with +/-1 tolerance using conditional formatin 2
Count the number of colored cells in a column 5
Change background color using conditional formatting 4

Top