Conditional Formulas for Changing Cell Color

M

mw2222

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?
 
J

John C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 2
Logical formatting for multiple values 1
Excel VBA 1
Counting Colors of Cells set by Conditional Formatting 2
Changing Color of the Cell under Certain Conditions 8
Conditional Formatting Confusion 8
Conditional formatting using text and exceptions 4
Conditional format cell containing hyperlink 2

Top