Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting query | New Users to Excel | |||
conditional sum query | Excel Worksheet Functions | |||
Conditional formatting query | Excel Worksheet Functions | |||
Conditional MS Query | Excel Worksheet Functions | |||
How to preserve conditional formatting on a web query table result | Excel Discussion (Misc queries) |