color changing of cells

C

changetires

I have a calculation in cell A1, simple E7-F7. I want this cell to
change to a red fill color when the number is negative, but I do not
want the negative number to be displayed just the cell color to change.
Any way to do this easily?

Ed
 
B

Bearacade

use Conditional Formating. and make the cell fill to be red and text
color to be the same
 
C

changetires

but I still want to be able to read the number just in a positive number
format.
 
B

Bearacade

That's why you use conditional formatting
go to Format -> Conditional Formatting

in Condition 1, put in
Cell Value Is
Less than
0
Click on Format
Click on Patterns and select RED
Click on Font and select the same RED

and click OK
 
C

changetires

Ok now the whole cell is read and cant read any number although there i
a number in ther
 
C

changetires

I should have said I didnt want the negative sign in front of the number
but still wanted the number itself to display. The red color of the
cell would have to me that it was a negative number.

ed
 
B

Bearacade

Ahh!

Keep the conditional format. but make the text black. Background Red
if < 0

go to A1, and format the cell, set it to custom and enter the
following:

#,##0.00;#,##0.00

that will give you a number with 2 decimal in the end, adjust as needed
 
C

changetires

WOW!

Today Bearacade is my best friend. Man that works like a champ. Where
can I learn all these codes. I think I am spending more time writing in
here than working on our process sheets. Thanks again killllller.

ed
 
Top