| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting
THANK YOU :-)
"muddan madhu" wrote: try this =IF(AND(A2=0,A2<=100),A2*2,IF(AND(A2100,A2<=200) ,A2*3,"")) On Nov 17, 3:43 pm, Chris wrote: i am trying to put a format in excel of if box A2 is between 0-100 then *2 or if it's between 101-200 then *3 Can anyone help please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Hybrid Mode
