View Single Post
  #7   Report Post  
Old February 1st 05, 10:49 PM
Geremia Doan
 
Posts: n/a
Default

JulieD,
I am not very good at explaining these things and I apologize for that.
When I set up multiple conditions in Conditional Formatting, conditions 1 and
2 override condition 3, when condition 1 contains the 'banding' formula and
conditions 2 and 3 contain a 'is greater' or 'is less' formula with a format
of BOLD or BOLD ITALICIZED. So what happens is every other row is shaded,
but where conditions 2 and 3 would normally apply, making the contents of the
cell BOLD or BOLD ITALICIZED, the cell is shaded and the contents of the cell
are neither BOLD or ITALICIZED. If I change Conditonal Formatting so that
the 'banding' formula is condition 3, conditions 1 and 2 override condition 3
making the contents of the cell BOLD or BOLD ITALICIZED, but the cell is not
shaded.
If that still doesn't make sense, maybe you could take a peek at the
spreadsheet. You can see it at home.comcast.net/~geremiadoan/ and its the
link labeled Territory.xls. It's the second item from the top.
My aim is to shade every other row, yet still be able to sort and keep this
shading, as well as other conditional formatting that I already have set up.
The copy that I have up on the website was saved prior to my having attempted
the shading of odd numbered rows, but after having set up conditional
formatting to change contents of cells to BOLD and BOLD ITALICIZED.

Thank you for your help. You're the best!

Geremia

"JulieD" wrote:

Hi Geremia

what is the formula you're using in conditional formatting for
"Using CF, I made it so that whenever the date in one of the 68 cells in the
column is prior to 6 months ago, it becoms bold and
italicized."

as it's difficult to tie this in with your first example.

Cheers
JulieD


"Geremia Doan" wrote in message
...
Let me clarify what I want. I have a column of 68 cells. Each cell has a
date in it. I have another cell below it that always has the date it was
6
months ago in it. Using CF, I made it so that whenever the date in one of
the 68 cells in the column is prior to 6 months ago, it becoms bold and
italicized.
I also want to set up banding so that it's easier to follow the rows when
I
print out the spreadsheet.
I am having trouble accomplishing both of those things at the same time.
I guess I could put it this way: I want to shade all odd rows in a range.
In all odd and even rows of my particular column, I want a bold and
italicized font if the date in the cell is older than 6 months; and I want
to
keep the shading in each odd row.
Does that make better sense?
Thank you for your help and patience.

"JulieD" wrote:

Hi Geremia

not sure what you want Bold & Italicized - all the "banded" rows or row
#69.

--so all odd rows banded, bold & italicized when f69D72
1st condition
=AND(MOD(ROW()-1,2)+1<=1,$F$69$D$72)
-set formatting for banding colour & font bold & italicized

2nd condition
=MOD(ROW()-1,2)+1<=1

--only row 69 bold & italicized
1st condition
=AND(MOD(ROW()-1,2)+1<=1,$F$69$D$72,ROW()=69)
-set formatting for banding colour & font bold & italicized

2nd condition
- as above

Hope this helps
Cheers
JulieD

"Geremia Doan" wrote:

I can set up banding using Conditional Formatting fust fine. The
problem
I
am having is that there are other conditions I need to have happen at
the
same time. For example, when cell F69 is greater than cell D72, I
need
it to
be BOLD and ITALICIZED. When I use the banding formula in Conditional
Formatting as the first Condition, it overrides the other conditions,
so
the
cell is shaded, but not BOLD and ITALICIZED. If I make it the last
Condition, the BOLD and ITALICIZED condition overrides the banding
Condition.
Does anyone know if there is a way to get around this problem? A
lengthy
formula, perhaps, to put into Conditional Formatting that will
perform
both
functions?