font color in formulae

  • Thread starter Thread starter Guest
  • Start date Start date
Terry

Format>Cells>Number>Number>Negative Numbers. Set your format here.

Gord Dibben Excel MVP
 
-----Original Message-----
When rounding to -3 the cell font color went red. How do i change t ot black?
.
Click to expand...
If you just need quick fix for now, you should be able to
click on cell and change color of that cell for now using
regular A color icon.

BUT, if you need to fix it so it doesn't change the next
time you open the spreadsheet, check the Conditional
Formatting settings.

Not sure how your spreadsheet is formatted, but you may
want to check your Conditional Format settings. Many
financial spreadsheets are set up with conditional
formatting so that if number is less than zero, then it
should appear in red. Try clicking on your cell and then
click Format>Auto-Formatting and see if you see any
formula telling your spreadsheet to make negative numbers
red. If so, remove formula.

Hope that helps...if not, shoot me copy of spreadsheet
and I'll see what I can do. Good Luck...
 
Back
Top