LinkBack URL
About LinkBacks
Looking to put the gridlines in automatically when data is entered in a cell. So when i enter a date, 29 cells in that row automatically have the gridlines put around them.
TIA
Los
Looking to put the gridlines in automatically when data is entered in a cell. So when i enter a date, 29 cells in that row automatically have the gridlines put around them.
TIA
Los
Select all of the columns you want to format.
Select Conditional Formatting >> New Rule >> use formula...
In the formula box put:
=$A1<>"" (or the column with the date, if not column A)
Click Format and choose your borders
Last edited by protonLeah; 10-23-2015 at 02:30 PM.
Ben Van Johnson
That auto magically put a border around the cells automatically. I only want a border if there is a date entered.
I have attached the file, maybe i am putting it in wrong.
any help would be greatly appreciated
George
Im stumped, I keep trying various formulas and nothing seems to work....I know there has to be an easy solution
Los
The reason why you have the borders is because you chose A2:AC2 but in the formula you put
$A1<>""
It should be $A2<>""
You should also select multiple rows when assigning the conditional formatting so you don't have to keep repeating it (or copying it) down the page.
Make sense?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you ChemistB ....i knew it was something easy
Los
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks