Format a Data Table

T

techgirl

Board Regular
Joined
Sep 16, 2002
Messages
178
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
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
 
Upvote 0
It worked in the spreadsheet but didn't carry over to the charts datatable.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Conditional Formatting in Excel Table and Ignore Blanks Not Working
Replies
3
Views
227
Joe4
Joe4
F
  • Question
Save as PDF file but exclude blank pages (using macro)
2
Replies
13
Views
498
feni1388
F
Y
  • Question
Data Update using VBA
Replies
0
Views
115
yogeshCR7
Y
A
  • Solved
Exclude columns in listbox on userform except first two columns & last column
2
Replies
16
Views
325
abdelfattah
A
duteberta
  • Question
Table filter search box VBA not working...
2
Replies
12
Views
151
Akuini
Akuini

Forum statistics

Threads
1,214,431
Messages
6,119,457
Members
448,898
Latest member
drewmorgan128

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top