Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like when I enter a negative number in a cell to automatically be
red. Is there anyway I can do that? |
#2
![]() |
|||
|
|||
![]()
Do you want the number to be red, or the cell's shading?
If it's the number, use a custom format such as #,##0;[Red]-#,##0 If it's the shading, use Format Conditional Formatting Set 'Cell Value Is' along with 'Less Than' and '0' Then click on the format button, go to the Patterns tab, pick your color, and OK out of the dialog box. Copy that formatting to all the cells you want treated that way. "tnlovesme" wrote: I would like when I enter a negative number in a cell to automatically be red. Is there anyway I can do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|