Format a Data Table

[techgirl]

I have a data table, 6 rows - 2 columns. The last three cells in column one is empty, the first three cells in column two is empty. Is there any way to format the empty cells to be a specific color.

 

[jss1234]

Use conditional formatting in the format menu:

Formula is =ISBLANK(A2)

Where A2 is the cell you are in

Set format and copy and paste formats to the data table

 

[techgirl]

It worked in the spreadsheet but didn't carry over to the charts datatable.