Placing Borders on a row of cells - Conditionally

[jeff6605]

I have a spreadsheet I am developing that will be used by several different people as they do their research and add items to keep track of tasks.

Each item added is on one row, using eight columns. The first cell is the date followed by info on the item they are logging. Cells for that row that are being used have a standard border around each cell making up that 8 column row. I want a conditional format cammand that when a user starts a log on a new row that row becomes automatically populated with a border around the 1x8 row.

I can conditionally format a cell, where if cell is greater than 1: show boarder around cell. That is easy. But how do I have it conditionally formated to say when a user starts a new row and enters cell 1x1 with the date it will populate the entire 1x8 row with a boarder. The problem occurs with the former condition where the row has a couple cells without info (not greater than 1) the cell is not bordered. I want to eliminate the manual border command in this scenario.

[bentleybob]

Specify your formula conditional formatting to be =$a3<>"" and then the format to be outlined borders or whatever. Apply this to your entire range. Than if the user puts anything in a cell in Column A, you'll get borders in that row.

[jeff6605]

Specify your formula conditional formatting to be =$a3<>"" and then the format to be outlined borders or whatever. Apply this to your entire range. Than if the user puts anything in a cell in Column A, you'll get borders in that row.

Thanks, However, when applied I am getting a border in that row even without data in Column A. When Data is not in Column A I would like it to stay blank...

edit-In Print view it seems to be working, but in normal edit mode the borders show? Anyway to turn off borders if not active in edit view?