Format a Data Table

techgirl

Board Regular
Joined
Sep 16, 2002
Messages
164
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.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

jss1234

Active Member
Joined
May 28, 2004
Messages
434
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

Board Regular
Joined
Sep 16, 2002
Messages
164
It worked in the spreadsheet but didn't carry over to the charts datatable.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,921
Messages
5,575,043
Members
412,636
Latest member
XinZ
Top