| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formatting
i want to use conditional formatting. i would like a
cell to be shaded dependant on whether another cell is blank or not. |
|
#2
|
|||
|
|||
|
Use formula is and
=other_cell="" will format if it is blank =other_cell<"" will format if it is not blank Regards, Peo Sjoblom "frank" wrote: i want to use conditional formatting. i would like a cell to be shaded dependant on whether another cell is blank or not. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format of data tables in charts | Charts and Charting in Excel | |||
| Conditional formatting in Charts? | Charts and Charting in Excel | |||
| Conditional format | Excel Discussion (Misc queries) | |||
| copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Linear Mode
