| Home |
| Search |
| Today's Posts |
|
#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 . |
| 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 | |||
Threaded Mode
