Software
Greetings,
I asked that very question a couple of months ago. I received several answers that referred to the Conditional Formatting function that would indeed assign a color depending on a formula result.
A link to my question and those greatanswers follows:
https://www.techrepublic.com/forumqa/thread_detail.jhtml?thread_id=67467
(REMOVE SPACES from the pasted URL.)
Maxwell
.
.
Also see these links for more articles on Conditional Formatting:
http://j-walk.com/ss/excel/usertips/tip006.htm
http://businesssoft.about.com/library/weekly/aa012501a.htm
http://msdn.microsoft.com/library/en-us/dnexcl2k/html/xlnumfmt.asp?frame=true
http://www.zdnet.com/pcmag/pctech/content/solutions/ss1707a.htm
(Don't forget to remove those pesky SPACES.)
Good luck,
Maxwell
by dennisbv
by dklippert
As mentioned, conditional formatting is the way to go, but you can also use custom cell formatting.
In the Format>Cells choose custom and use something like [Red][>=150]General;General
by dennisbv
by dennisbv
This discussion is closed to new replies.
Sort by Trending