How To Fill Excel Cell With Color Based On Value
MS Excel 2010: Alter the fill color of a cell based on the value of an adjacent prison cell
This Excel tutorial explains how to utilise conditional formatting to alter the make full color of a prison cell based on the value of another cell in Excel 2010 (with screenshots and step-by-step instructions).
Question: In Microsoft Excel 2010, I'thousand trying to apply a fill color to a cell based on the value in an adjacent cell. How can I do this?
Reply: If you wish to change the make full colour in a cell based on the value of an adjacent jail cell, you will need to apply conditional formatting.
In this case, we have a table in cells Q1 to S10 that brandish the fill up colors that we desire to use for each rock type. So in this case, we want to display a yellow make full color if the Rock Type is Shale, an orange fill color if the Stone Type is Quartz, and then on.
Nosotros use a VLOOKUP in cell F14 to F16 to pull the appropriate Stone Type from the Q1:S10 table. Now the hard part. We want to display the respective fill colour in cells E14 to E16 based on the Rock Type returned. We are unable to use a VLOOKUP to pull the fill color, then we will have to utilise conditional formatting.
To exercise this, select the range of cells that you wish to utilise the conditional formatting to. In this case, we've selected cells E14 to E16. Then select the Habitation tab in the toolbar at the top of the screen. And so in the Styles group, click on the Provisional Formatting drop-down and select Manage Rules.
When the Conditional Formatting Rules Manager window appears, click on the "New Rule" button to enter the showtime status.
When the New Formatting Rule window appears, select Use a formula to determine which cells to format equally the rule type.
And so type the post-obit formula:
=F14="Shale"
Side by side, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.
When the Format Cells window appears, select the formatting weather that yous wish to apply. In this instance, we've selected yellow equally the Fill up Colour. Then click on the OK button.
When you return to the New Formatting Rule window, you lot should run into the preview of the formatting in the Preview box. In this example, the preview box shows the fill color of xanthous. Next click on the OK button.
This will return you to the Conditional Formatting Rules Manager window. You tin now view the kickoff provisional formatting condition. We will need to add together a condition for each make full color by clicking on the New Rule push button and repeating the previous steps.
Once all of the weather have been entered, you should run across something like the picture below. Click on the OK button.
At present when you return to the spreadsheet, the conditional formatting will be applied in cells E14 to E16.
Source: https://www.techonthenet.com/excel/questions/cond_format9_2010.php
Posted by: watsonprignoced.blogspot.com
0 Response to "How To Fill Excel Cell With Color Based On Value"
Post a Comment