Can conditional format pattern color shine through on page-b

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
All I can see is gray, whether the format is tripped or not. XL02 on Win2K.

Is this a fundamental limitatation of Page Break Preview? Or am I just high here?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
I'm showing grey on Print Preview but color on Page Break Preview. Excel 2000.
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
Hi not sure if this post is on the level but

Preview is thick boarder in blue if in page break, or thin grey if not in preview

In FULL XP windows Pro and Excel 2002 (office Pro)
 

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961
I'm talking about the gray area.
Go alt-view-Page Break Preview; find the gray area.
Conditional format a cell there to be red.

Now excite the condition that turns it red. Or embarass the cell. Whatever - make it red. I seem to be unable to myself.

Now that I've explained all that, would someone simply confirm that they duplicate this pure-gray condition?
 

Gates Is Antichrist

Well-known Member
Joined
Aug 15, 2002
Messages
1,961

ADVERTISEMENT

I think I just realized why no one sees this. It requires that a print area be defined.

I guess I should have mentioned that earlier :oops:

_________________
______________
Because he is.
This message was edited by Gates Is Antichrist on 2002-10-30 17:41
 

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Yes, Lord, I confirm that conditional format does not appear on the grey area, probably because the page break preview is only concerned with the print area you set.
 

Forum statistics

Threads
1,144,510
Messages
5,724,782
Members
422,578
Latest member
annsalinas

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
Top