ExcelBanter - Conditional Formulas for Changing Cell Color

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional Formulas for Changing Cell Color (https://www.excelbanter.com/excel-worksheet-functions/205274-conditional-formulas-changing-cell-color.html)

mw2222

Conditional Formulas for Changing Cell Color

I would like to set up a formula so that if someone types "x" into cell A10,
then the background color changes in cell A1. Can anyone help?

John C[_2_]

Conditional Formulas for Changing Cell Color

Click in cell A1, go to menu Format|Conditional Formatting, change drop down
to Formula:
=A10="x"
--
John C

"mw2222" wrote:

I would like to set up a formula so that if someone types "x" into cell A10,
then the background color changes in cell A1. Can anyone help?

mw2222

Conditional Formulas for Changing Cell Color

John C,

It worked! Thank you so much!

"John C" wrote:

Click in cell A1, go to menu Format|Conditional Formatting, change drop down
to Formula:
=A10="x"
--
John C

"mw2222" wrote:

I would like to set up a formula so that if someone types "x" into cell A10,
then the background color changes in cell A1. Can anyone help?

All times are GMT +1. The time now is 07:23 AM.