How do I change cell color based on value in another cell?

How do I change cell color based on value in another cell?

3 Answers

1. Select cell B3 and click the Conditional Formatting button in the ribbon and choose “New Rule”.
2. Select “Use a formula to determine which cells to format”
3. Enter the formula: =IF(B2=”X”,IF(B3=”Y”, TRUE, FALSE),FALSE) , and choose to fill green when this is true.

How do I change cell color in Excel based on text input in another cell?

Apply conditional formatting based on text in a cell

1. Select the cells you want to apply conditional formatting to. Click the first cell in the range, and then drag to the last cell.
2. Click HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains.
3. Select the color format for the text, and click OK.

How do I change the color of a Find box in Excel?

Here’s how:

1. Select the cells you want to highlight. Tips:
2. Click Home > the arrow next to Fill Color. , or press Alt+H, H.
3. Under Theme Colors or Standard Colors, pick the color you want. To use a custom color, click More Colors, and then in the Colors dialog box select the color you want.

How to change the row color when the tick box is ticked?

Conditional formatting formula to change the row color when the tick box ticked. Here, the row color changes when the tick box is ticked. The logic behind the above two types of conditional formatting is simple. By default, the value of the cell that containing the tick box is the Boolean FALSE. When ticked it changes to TRUE.

How to change cell value or color when checkbox is checked?

This section will show you how to change a specified cell color when checkbox is checked with VBA code. 1. Right click the Sheet Tabwith the cell color you need to change based on checkbox, then clickView Codefrom the right-clicking menu. 2.

How to make a tick box Go Green in Excel?

I have a cell with a check box. I want another cell which contains a date to go green when the tick box is checked. On the other hand, if you want the whole range/column to be highlighted use the following formula: Pay attention to the second $ sign.

How to change the color of a cell?

1 Right click the Sheet Tab with the cell color you need to change based on checkbox, then click View Code from the right-clicking menu. 2 In the Microsoft Visual Basic for Applications window, please copy and paste the below VBA code into the Code window. 3 Select a cell you need to change its background color, then check the checkbox.