| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I search for any cell containing data and apply conditiona.
hi, I have a spreadsheet where when the data has been entered I wish to
apply conditional formatting so that any cell which contains any type of data has a border around it. Does anyone know who to do this. |
|
#2
|
|||
|
|||
|
Hi
clcik on Format|Conditional formatting, then change cel value option not equal to, and enter ="". Under Format, select borders, select the border you want and OK out of the windows. "Dawn" wrote: hi, I have a spreadsheet where when the data has been entered I wish to apply conditional formatting so that any cell which contains any type of data has a border around it. Does anyone know who to do this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
Linear Mode
