How do you make a cell highlight if condition is met in another cell? Enter the formula: =IF(B2=”X”,IF(B3=”Y”, TRUE, FALSE),FALSE), and choose to fill green when this is true.Select “Use a formula to determine which cells to format”.Select cell B3 and click the Conditional Formatting button in the ribbon and choose “New Rule”.How do I change the color of a cell in Excel based on another cell value? Enter the formula in the corresponding box.In the New Formatting Rule window, select Use a formula to determine which cells to format.On the Home tab, in the Styles group, click Conditional formatting > New Rule….What is a conditional formula in Excel?Ĭan I do conditional formatting in Excel based on another cell?Įxcel formulas for conditional formatting based on cell value.How do you conditionally format a column based on the result from another column?.How do you make a cell highlight if condition is met in another cell?.How do I change the color of a cell in Excel based on another cell value?.

Can I do conditional formatting in Excel based on another cell?.

How to change bar color in excel