Format a blank cell based on the value of another cell

T

tracktor

I want to change the format of a blank cell (B2) when the value in another
cell (A2) equals “Xâ€. I have tried to use conditioanal formating, but there
is a formula in cell A2 that creates the value “Xâ€, and I can’t seem to get
the right info into the conditional formatting in cell B2.

I have been able to accomplish this by creating conditional formatting in
cells A2, B1, C2, and B3 by putting a boarder adjacent to cell B2 based on
formulas I have created in eache of those cells, esentially putting a boarder
around cell B2. But I know there is an better, cleaner, and easier way.
 
R

Rick Rothstein \(MVP - VB\)

In the Conditional Formatting dialog of B2, select "Formula Is" in the drop
down and use this formula...

=A2="X"

Click the Format button and select whatever formatting you want.

Rick
 
T

tracktor

Thanks again Rick. If you can answer my question about Grouping Checkboxes
you will be batting 1000, and I will be in heaven.
 

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 Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
If value is then copy 2
Change the colour of a cell if another named cell is blank 2
Conditional Format Won't Update Cell 8
Fill cells based on the other 3 cells unique combination the value on the target cell 0
Adding cells until they are greater than a lookup cell and returning a value 1
conditional format on column based on cell value 2
Word macro that can call cells out of Excel for a find and replace 0

Top