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

Changing row background from external program 0
Match table shading (color) to Visio color/Transparency 1
Logical formatting for multiple values 1
Function for summing or counting cells based on a specified fill color 3
Newbie Help - IF Yes No Function 0
Copy the content of a cell with Formula 1
Need help modifying code 0
Counting Colors of Cells set by Conditional Formatting 2

Top