| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to change color of negative cell
I am creating a table with percentages and I want it to make the
negative %s red. How would I code/format for this? Thanks, Jackie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to change color of negative cell
do a custom number format (format=cells=Number Tab then Custom)
0.0%;[Red]0.0% -- Regards, Tom Ogilvy " wrote: I am creating a table with percentages and I want it to make the negative %s red. How would I code/format for this? Thanks, Jackie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| fill color to a cell when the value is negative or positi | Excel Programming | |||
| Change the interior color of a cell - Code Review | Excel Programming | |||
| Change color to red when fraction is negative | Excel Worksheet Functions | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
Linear Mode
