| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Hybrid Mode
