If Im understanding correctly you are trying to create a formula that will change column Bs value when A is equal to Yes or No.

How to use conditional formatting in excel to change text color. In the New Formatting Rule dialog choose Use a formula to determine which cells to format. Learn how to use colour scales in Excel. Then choose New Rule.

Choose Home Styles Conditional Formatting Manage Rules. Click on the Format option to open the Format Cells dialogue box. Click on the Format button and select your desired formatting.

In Excel the Conditional Formatting can do a favor on the changing font color by cell. Add change find or clear conditional formats. In the Text that Contains box on the left enter the text you want highlighted.

Excel formula change text color. In the New Formatting Rule dialog click Use a formula to determine which cells to format in Select a Rule Type section and type C1G2 into the Format values where this formula is true. In the edit box enter this formula.

Apply conditional formatting to quickly analyze data. Select a two-color scale. Thanks to colour scales youll be able to design a data table with a clear overview of the maximum the minimum as.

The formula entered will return TRUE when the cell contains the word Overdue and will therefore format the text in those cells with a background color of red. NOTISERRORSEARCH1A11 For green use the formula NOTISERRORSEARCH2A11 I hope itll be helpful. 1 Change font color if negativepositive.