how do I search for any cell containing data and apply conditiona.

D

Dawn

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.
 
K

Kassie

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.
 
Top