| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
color changing of cells
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 -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
color changing of cells
use Conditional Formating. and make the cell fill to be red and text color to be the same -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
color changing of cells
but I still want to be able to read the number just in a positive number format. -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
color changing of cells
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 -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
color changing of cells
Ok now the whole cell is read and cant read any number although there is a number in there -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
color changing of cells
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 -- changetires ------------------------------------------------------------------------ changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414 View this thread: http://www.excelforum.com/showthread...hreadid=552325 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Help adding text values | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Hybrid Mode
