G Guest Nov 16, 2007 #1 I would like the cell/font to turn red if a number goes below a critical point eg.<10
G Guest Nov 16, 2007 #2 Conditional Formatting will do what you want: Format > Conditional Format (then follow prompts) Take a look at this site: http://www.contextures.com/xlCondFormat01.html http://www.contextures.com/xlCondFormat02.html Regards, Ryan---
Conditional Formatting will do what you want: Format > Conditional Format (then follow prompts) Take a look at this site: http://www.contextures.com/xlCondFormat01.html http://www.contextures.com/xlCondFormat02.html Regards, Ryan---