If then statements in Microsoft Excel?

Question

I would like to write a formula in MS Excel that would assign one of three fill colors depending upon a calculated value. Example - if 1A is less than 10, then fill with green, if 1A is between 10 and 15, then fill with yellow, if 1A is greater than 15, then fill with red. 

Can I write such a formula? Thanks for your help

garbo7441 · Accepted Answer

You cannot use a formula to change the interior color. However, you can use Conditional Formatting. Select cell A1 (1A). For Excel 2003, and prior, go to Format>Conditional Formatting...

Change the dropdown menu for Condition 1 to 'Formula is'. Enter this formula in the textbox to the right:

=A1<10

Then, click the 'Format' button and Select the 'Pattern' tab. Choose the color you wish to display. Click 'OK'.

Click the 'Add' button to add a second conditional format.

Change the dropdown menu for Condition 2 to 'Formula is'. Enter this formula in the textbox to the right:

=A1<16

Then, click the 'Format' button and Select the 'Pattern' tab. Choose the color you wish to display. Click 'OK'.

Click the 'Add' button to add a third conditional format.

Change the dropdown menu for Condition 3 to 'Formula is'. Enter this formula in the textbox to the right:

=A1>15

Then, click the 'Format' button and Select the 'Pattern' tab. Choose the color you wish to display. Click 'OK' twice.

esker · Answer

it somewhat is a VLOOKUP. Say your sheets are stated as Sheet1 and Sheet2. Your word is in Sheet1, A1. Your array of information is in Sheet2, A1 to B10. In Sheet1, B1 placed =VLOOKUP(A1,Sheet2!A1:B10,2,fake) this could return the adjoining value from Sheet2 to Sheet1. warning: deleting any information from Sheet 2 will invalidate this formulation. To "fix" the information in Sheet1 you may desire to repeat, Paste particular, values.

Trending News

If then statements in Microsoft Excel?

2 Answers