| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks Max! Your answer was very helpful, exactly what I wanted.
"Max" wrote: Try Conditional Formatting Suppose you want this to happen in say, col E Select col E Click Format Conditional Formatting Make the settings as: For Condition 1: Formula Is| =AND(E1<"",ISNUMBER(E1),E1=0) Click Format button Patterns tab Light green? OK Click Add For Condition 2: Formula Is| =AND(E1<"",ISNUMBER(E1),E1<0) Click Format button Patterns tab Pink? OK Click OK at the main dialog Now test it out by inputting some negative, positive values, zeroes and some text (e.g.: "ABC") in col E .. The cells' fill color should appear accordingly for the numbers, any cell with text entered or empty cells should not trigger the C.F. (i.e. no formatting should occur) -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- Bob T <Bob wrote in message ... I'd like to make a cell change color or the cell's font change color as the number in the cell changes from negative to positive or vice versa? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
