Thread: Change the font color based on value of cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Change the font color based on value of cell
Use Conditional Formatting.

See:

http://www.contextures.com/xlCondFormat01.html
--
Gary''s Student - gsnu200832


"Robin" wrote:

How do I get excel to change the font color based on the value in the cell,
e.g. 1 3 5 change font color to red, 0 00 change font color to green
Reply With QuoteReply With Quote