G Guest Sep 23, 2004 #1 Can I use an "If - Then " statement in setting the background color of a cell or the border of a cell?
Can I use an "If - Then " statement in setting the background color of a cell or the border of a cell?
M Max Sep 24, 2004 #2 Yes, via conditional formatting A simple example: Suppose we want cell A1 to be auto-formatted: (with font in red/bold, fill color in yellow, outline border) if the value in A1 exceeds 10 Select A1 Click Format > Conditional Formatting Under Condition 1, make the settings: Cell value is | greater than | 10 Click Format button, then format to taste ..: Font tab: red/bold Patterns tab: yellow (fill color) Border tab: Outline Click OK Click OK at the main dialog Test it out by inputting a couple of values into A1 to activate the conditional formatting
Yes, via conditional formatting A simple example: Suppose we want cell A1 to be auto-formatted: (with font in red/bold, fill color in yellow, outline border) if the value in A1 exceeds 10 Select A1 Click Format > Conditional Formatting Under Condition 1, make the settings: Cell value is | greater than | 10 Click Format button, then format to taste ..: Font tab: red/bold Patterns tab: yellow (fill color) Border tab: Outline Click OK Click OK at the main dialog Test it out by inputting a couple of values into A1 to activate the conditional formatting
