| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number Format Syntax
What I want to do is format cell(s) so that if the value is less than 100, I
want the number in red. If it is 100 or greater, make black. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Format Syntax
It also needs to be in percentage
less than 100% Red, 100% or greater Black |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Format Syntax
On Sat, 22 Jan 2005 09:11:06 -0800, Tugger
wrote: It also needs to be in percentage less than 100% Red, 100% or greater Black Format/Cells/Custom Type: [Red][<1]0.00%;0.00% --ron |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Format Syntax
Select your range of cells, click Ctrl+1, select Number
tab, click "Custom", and insert this to the right: [Red][<1]0.00%;[Black][=1]0.00%;General HTH Jason Atlanta, GA -----Original Message----- What I want to do is format cell(s) so that if the value is less than 100, I want the number in red. If it is 100 or greater, make black. Thanks . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Format Syntax
[Red][<1]0%;0%
is one way -- HTH RP (remove nothere from the email address if mailing direct) "Tugger" wrote in message ... It also needs to be in percentage less than 100% Red, 100% or greater Black |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Number Format Syntax
Thank you very much guys!
"Jason Morin" wrote: Select your range of cells, click Ctrl+1, select Number tab, click "Custom", and insert this to the right: [Red][<1]0.00%;[Black][=1]0.00%;General HTH Jason Atlanta, GA -----Original Message----- What I want to do is format cell(s) so that if the value is less than 100, I want the number in red. If it is 100 or greater, make black. Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| Custom Format syntax Q | Excel Discussion (Misc queries) | |||
| WHAT SYNTAX IS USED TO ROUND A 4-DIGIT NUMBER TO THE NEAREST THOUS | Excel Discussion (Misc queries) | |||
| Number format based on number format of another cell in another workbook | Excel Programming | |||
| Syntax To Insert A Number Into One TrxtBox If A Different TextBox Has A Date That Is = 1/1/98 | Excel Programming | |||
Linear Mode
