ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Format a blank cell based on the value of another cell (https://www.excelbanter.com/excel-worksheet-functions/187876-format-blank-cell-based-value-another-cell.html)

tracktor

Format a blank cell based on the value of another cell
 
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 cant 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.


Rick Rothstein \(MVP - VB\)[_468_]

Format a blank cell based on the value of another cell
 
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


"tracktor" wrote in message
...
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 cant 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.



tracktor

Format a blank cell based on the value of another cell
 
Thanks again Rick. If you can answer my question about Grouping Checkboxes
you will be batting 1000, and I will be in heaven.

"Rick Rothstein (MVP - VB)" wrote:

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


"tracktor" wrote in message
...
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 cant 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.





All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com