WebFeb 24, 2016 · Other than that little trick turning negative numbers green with custom formatting. Conditional formatting is the only way to apply formats to cells based on a formula result. You'd have to use VBA. Code: Sub Test If Range ("Z12").Value = "American Airlines" Then Range ("Z12").Interior.Color = vbgreen End If End Sub. 0. WebI want to know how to change color to different cells based on another cells text. For example, if I change or add a text word "Pass" to cell F1, I would want cell F1 to turn green and automatically have B1 turn blue. In the same token, if I change F1 to "Fail", I would want F1 to turn red and have B1 to turn red.

Conditional formatting based on another cell - Excel formula

WebSelect the cells you want to apply format rules to. Click Format Conditional formatting. A toolbar will open to the right. Create a rule. Single color: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. http://officedigests.com/excel-sumif-color/ oxygen in ground state

How to Apply Conditional Formatting to Color Text in …

WebJan 8, 2015 · You conditional formatting on another sheet will reference this formula cell and set the colour of the new cell. You would use the following formula in the named … WebTo apply conditional formatting based on a value in another cell, you can create a rule based on a simple formula. In the example shown, the formula used to apply conditional formatting to the range C5:G15 is: Web In the Format Cells dialog box that opens, select the Font tab (if not activated already) Click on the Color option and select the red color jeffrey aoki clovis ca