G
Guest
I want to identify a specific cell by highlighting it with a cell fill color
when an "if" statement returns a "ture" response. How do I do this?
when an "if" statement returns a "ture" response. How do I do this?
I guess my question was not clear. I want to change the highliting of the
sell, not the cell content. (e.g. IF X=A, "B" with cell highlighted, "B"
winhout cell highlighted.)
To be honest, I found both the question and the response to be very confusing.
T. Valko said:Try this...
Assume the cell in question is A1
Select cell A1
Goto Home tab>Styles>Conditional Formatting>Manage Rules
Click New Rule>Use a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OK>OK>Apply
Now, click New Rule and repeat the process for each of the conditions.
This was much easier in previous versions of Excel!
T. Valko said:Try this...
Assume the cell in question is A1
Select cell A1
Goto Home tab>Styles>Conditional Formatting>Manage Rules
Click New Rule>Use a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OK>OK>Apply
Now, click New Rule and repeat the process for each of the conditions.
This was much easier in previous versions of Excel!
T. Valko said:Try this...
Assume the cell in question is A1
Select cell A1
Goto Home tab>Styles>Conditional Formatting>Manage Rules
Click New Rule>Use a formula to determine.....
Enter this formula in the box: =A1="I"
Click the Format button
Select the desired style(s)
OK>OK>Apply
Now, click New Rule and repeat the process for each of the conditions.
This was much easier in previous versions of Excel!
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.