Conditional Formatting Query
 

Dear all,

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:

=AND(COLUMN()<=16,ROW()<=24)

Nb.[coordinates: top left (0,0), bottom right (16,24)]

I now wish to to do the same for a U shaped area made up of three boxes with
coordinates,

Top left , Bottom Right
1: (0,0), (16,24)
2: (16,0), (32,12)
3: (32,0), (48,24)

Any ideas?

Help would be much appreciated.


Thanking-you in advance,

Neil

Conditional Formatting Query
 

Use AND conditions to define each box (with = top left corner, <= bottom
right), then use OR to combine the 3 boxes together.
--
David Biddulph

"Neil Pearce" wrote in message
...
Dear all,

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:

=AND(COLUMN()<=16,ROW()<=24)

Nb.[coordinates: top left (0,0), bottom right (16,24)]

I now wish to to do the same for a U shaped area made up of three boxes
with
coordinates,

Top left , Bottom Right
1: (0,0), (16,24)
2: (16,0), (32,12)
3: (32,0), (48,24)

Any ideas?

Help would be much appreciated.


Thanking-you in advance,

Neil

Conditional Formatting Query
 

Sat, 16 Feb 2008 15:00:01 -0800 from Neil Pearce
:

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:
=AND(COLUMN()<=16,ROW()<=24)

Nb.[coordinates: top left (0,0), bottom right (16,24)]

I now wish to to do the same for a U shaped area made up of three boxes with
coordinates,

Top left , Bottom Right
1: (0,0), (16,24)
2: (16,0), (32,12)
3: (32,0), (48,24)

Any ideas?

Well, conditional formatting lets you have three settings in a given
cell, so you could test your three conditions.

Or you could write a single setting, albeit a more complex one, which
would be an AND of two conditions. One condition would be inside the
region (0,0) to (48,24), and the other condition would be NOT within
the "hollow inside" of the U. I don't understand your coordinate
system, so I don't feel like I can take a stab at writing the
formula, but I hope that gives you the idea.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?

Conditional Formatting Query
 

Doing it Stan's way would be:
=AND(COLUMN()<=48,ROW()<=24,NOT(AND(COLUMN()=16,C OLUMN()<=32,ROW()=12,ROW()<=24)))
--
David Biddulph

"Stan Brown" wrote in message
t...

Well, conditional formatting lets you have three settings in a given
cell, so you could test your three conditions.

Or you could write a single setting, albeit a more complex one, which
would be an AND of two conditions. One condition would be inside the
region (0,0) to (48,24), and the other condition would be NOT within
the "hollow inside" of the U. I don't understand your coordinate
system, so I don't feel like I can take a stab at writing the
formula, but I hope that gives you the idea.

Sat, 16 Feb 2008 15:00:01 -0800 from Neil Pearce
:

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:
=AND(COLUMN()<=16,ROW()<=24)

Nb.[coordinates: top left (0,0), bottom right (16,24)]

I now wish to to do the same for a U shaped area made up of three boxes
with
coordinates,

Top left , Bottom Right
1: (0,0), (16,24)
2: (16,0), (32,12)
3: (32,0), (48,24)

Any ideas?

Conditional Formatting Query
 

David & Stan,

Thanking-you. Your help is greatly appreciated.


Cheers,

Neil

"David Biddulph" wrote:

Doing it Stan's way would be:
=AND(COLUMN()<=48,ROW()<=24,NOT(AND(COLUMN()=16,C OLUMN()<=32,ROW()=12,ROW()<=24)))
--
David Biddulph

"Stan Brown" wrote in message
t...

Well, conditional formatting lets you have three settings in a given
cell, so you could test your three conditions.

Or you could write a single setting, albeit a more complex one, which
would be an AND of two conditions. One condition would be inside the
region (0,0) to (48,24), and the other condition would be NOT within
the "hollow inside" of the U. I don't understand your coordinate
system, so I don't feel like I can take a stab at writing the
formula, but I hope that gives you the idea.

Sat, 16 Feb 2008 15:00:01 -0800 from Neil Pearce
:

I've been using CONDITIONAL FORMATTING to fill cells in visually
illustrating a rectangle based on a length and width using the following
formula:
=AND(COLUMN()<=16,ROW()<=24)

Nb.[coordinates: top left (0,0), bottom right (16,24)]

I now wish to to do the same for a U shaped area made up of three boxes
with
coordinates,

Top left , Bottom Right
1: (0,0), (16,24)
2: (16,0), (32,12)
3: (32,0), (48,24)

Any ideas?