![]() |
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. |
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. |
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