Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Autoformat borders when new entries entered
- Thread starter Anna22
- Start date
You could select the entire sheet, and do menu command Format/Conditional Formatting, and choose
Cell Value Is
not equal to
=""
and press the Format button, and choose your borders in the Border tab. Pres OK to confirm Format, press OK to complete Conditional Format.
Cheers, Glenn.
My grandfather was ill, and my grandmother smeared goose-grease on his back. He went downhill very quickly after that.
Cell Value Is
not equal to
=""
and press the Format button, and choose your borders in the Border tab. Pres OK to confirm Format, press OK to complete Conditional Format.
Cheers, Glenn.
My grandfather was ill, and my grandmother smeared goose-grease on his back. He went downhill very quickly after that.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question