Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
how can I create an if then statement which if the value of the cell a1 is XX
then the cell's background color becomes blue... if cell a2 is xy then color is green... and if value of a3 is yy then color is red... ANY HELP? -- sss |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
Use conditional formatting
Format - Conditional Formatting On Jun 11, 3:52 pm, sed wrote: how can I create an if then statement which if the value of the cell a1 is XX then the cell's background color becomes blue... if cell a2 is xy then color is green... and if value of a3 is yy then color is red... ANY HELP? -- sss |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then statement
sed
In addition to Tim879 when you get into the conditional formating window, choose "Formula is" then enter =A1="XX" Select format and formate as you want. select "Add" choose "Formula is" then enter =A2="XY" Formate as you want. Select "Add" Choose "Formula is" then enter =A3="YY" Formate as you want. Mike Rogers "sed" wrote: how can I create an if then statement which if the value of the cell a1 is XX then the cell's background color becomes blue... if cell a2 is xy then color is green... and if value of a3 is yy then color is red... ANY HELP? -- sss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
V LOOK UP AND IF STATEMENT | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |