| 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. |
| 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 | |||
Threaded Mode
