11 Oct 2010 at 16:20 #1 Will Gill Will Gill Don Joined 18 Oct 2002 Posts 56,670 Location Cornwall I've exhausted my excel and googling skills need a way to add a format so that once the value in a cell exceeds 80,000 it turns red is it this one? #,##0.00;[Red]-#,##0.00 if so, how?? muchos xx
I've exhausted my excel and googling skills need a way to add a format so that once the value in a cell exceeds 80,000 it turns red is it this one? #,##0.00;[Red]-#,##0.00 if so, how?? muchos xx
11 Oct 2010 at 16:25 #2 RavenLunatic RavenLunatic Associate Joined 18 Dec 2008 Posts 515 Perhaps conditional formatting is what you are looking for.
11 Oct 2010 at 16:29 #3 fretted fretted Associate Joined 4 Jan 2010 Posts 603 conditional formatting to turn the cell red, format->cells->number->custom to turn text red