Hello all,
I am looking to create black gridlines around all the cells that I have actual data in (without creating the gridlines on the blank cells).
Is there a way to do this?
Thanks!
Bryan
Hello all,
I am looking to create black gridlines around all the cells that I have actual data in (without creating the gridlines on the blank cells).
Is there a way to do this?
Thanks!
Bryan
Last edited by tiger10012; 10-11-2011 at 03:58 PM.
conditional formatting (see attached)
to set that up (started on cell A1)![]()
=NOT(ISBLANK(A1))
1) highlight cell A1
2) go to Home tab ->Conditional Formatting
3) select "new rule" --> use a formula option
4) =NOT(ISBLANK(A1)) in the rule box
5) click format button, set the borders you want
6) when done click OK to exit and copy / past the formats to other cells.
Last edited by GeneralDisarray; 10-07-2011 at 02:37 PM.
That did the trick! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks