| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting and IF Statements
I have a series of nested IF statements that looks at a column of numbers -
some of which are dollars, some of which are percentages. These may alternate depending on the data sheet being used ...is there any way to make sure the the cell formatting is copies as well? For example - for one product, in cell D1 I have IF(a1="Some Logic",B2,"Not Covered")...if B2 in one data sheet is $20, but then the next data sheet has it as 50%, on the second transfer, it shows up as $0. How can I copy the cell format properties as well? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting with IF statements | Excel Discussion (Misc queries) | |||
| Combining Text and If statements with varied character (bold, color, etc) formatting. | Excel Discussion (Misc queries) | |||
| Conditional formatting combined with multiple IF statements | Excel Worksheet Functions | |||
| Sorting or if statements reliant on formatting | Excel Worksheet Functions | |||
| Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
