Colouring Blank cells

melbin

New Member
Joined
Oct 17, 2017
Messages
8
What should be the formula to color blank cells yellow using conditional formatting. "" symbol is not working..
Can anyone help me please
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996
6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996
6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996
6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996
6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996

<tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
Hi Jim,

Thank yo so much for the reply. Please see the below data. I want to color the empty cells yellow.



6/11/2017$00%$3050%$10545%$4,802154%$4,937133%
6/18/2017$248$723%$549524%$5,534115%$6,339128%
6/25/2017$21787%$30429%$32359%$7,458135%$8,028127%
7/2/2017$220101%$45150%$371115%$8,658116%$9,294116%
7/9/2017$00%$00%$32888%$7,06282%$7,39080%
7/16/2017$315$60$621189%$6,90398%$7,899107%
7/23/2017$396126%$4575%$55489%$7,471108%$8,465107%
7/30/2017$418106%$45100%$784142%$10,898146%$12,146143%
8/6/2017$438105%$2964%$44457%$5,62952%$6,54054%
8/13/2017$473108%$2379%$461104%$7,110126%$527$0$8,594131%
8/20/2017$482102%$30130%$23751%$5,78781%$45085%$749$7,73590%
8/27/2017$41686%$45150%$384162%$8,120140%$33875%$72997%$10,032130%
9/3/2017$495119%$128284%$17746%$8,241101%$30791%$69195%$436$10,475104%
9/10/2017$32265%$4535%$357201%$6,65681%$312102%$793115%$488112%$8,97386%
9/17/2017$31297%$3169%$29181%$6,720101%$326104%$65683%$37477%$8,70897%
9/24/2017$392125%$63203%$18564%$8,252123%$351108%$973148%$551148%$10,767124%
10/1/2017$36694%$3149%$251135%$6,23476%$367105%$87390%$48388%$8,60580%
10/8/2017$540147%$1652%$13855%$6,697107%$376102%$1,030118%$42588%$9,223107%
10/15/2017$551102%$41256%$198143%$6,865103%$379101%$1,889183%$723170%$10,644115%
10/22/2017$572104%$69168%$18091%$7,000102%$5,400286%$1,500207%$14,721138%
10/29/2017$47383%$2333%$461256%$7,110102%$527$00%$8,999600%$17,593120%
Grand Total$13,723$1,868$11,041$183,343$4,259$13,783$13,979$241,996

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
I'm trying to insert the excel sheet but, it is not allowing me to do it.

Any way its B9 to Q66
 
Upvote 0
Begin by highlighting this range, then select conditional formatting, new rule, select "assign by formula" optio . In the textbox that comes up enter: = B9 = ""
Select format, Fill, Yellow, ok, ok...
Should work aftetwards...
 
Upvote 0
I'm trying to insert the excel sheet but, it is not allowing me to do it.
If you read the text it tells you when you try to post that, you will note that it tells you that your post has been Moderated and needs to await Moderator approval - trying to post it again, does not change that. You just need to be patient and wait for Moderator approval. I have down that now, so you can see them above.

Posts from new members with images or code inserted often get Moderated. Once you have been here a little while, that will not happen anymore.
 
Upvote 0
Thank you so much Jim.

I'm coloring a pivot table using this. If i add one more column and refresh the pivot table, the blank cells in the newly added column wont appear in yellow color right? What should I do to automatically color the blank cells yellow when i add new columns or rows?

Please refer the data i attached in the previous reply.
 
Upvote 0
Expand the separate range which is titled: "Range to apply cf" to include your revised range... hope that helps... Jim
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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