Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting with IF Statement
I would like to format a cell that will either show the
value as "LF" or as a quantity using the "(xx)" format. Although the following IF statement is in a modified format, the idea should be understandable to what I am trying to do. IF( G1 = "x", format cell Q1 as "lf", else format as "(xx)" ) Intended Results: If the user enters an x in cell G1, format the inputted number with the letters "lf" for linear feet. If the user does not enter an x in cell G1, format the inputted number with "( )" designating a quantity around the value. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with if statement | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATTING OR AN 'IF' STATEMENT? | Excel Discussion (Misc queries) | |||
Formatting Cells using an If Statement | Excel Worksheet Functions | |||
If Statement/Conditional Formatting | Excel Worksheet Functions | |||
How do I check formatting in an if-then statement | Excel Worksheet Functions |