Conditional formating formula

[gramoy]

Hi,

I'm trying to apply conditional formatting to a table so as that boarders only appear around a row when there is a numerical value in the first cell. leaving the rows bellow formatted until they are also populated

i'v been been unsuccessfully trying to use the If function e.g. =if(column(A:A)="","",...

any help or advice would be much appreciated.

Thanks

 

[dave3009]

Try

Formula Is: =ISNUMBER($A1) set desired format.

If the cell is blank or text then no format will be applied.