Okay, here is what I am trying to do, could someone tell me exactly and
specifically how to write it up and plug it into my macro? THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red entire ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold entire Row

Use conditional formatting with a formula of

=OR(AND(K1=13,K1<=98),K1100)

and form at as red

second as

=OR(K1<13,K1=99)

and format as bold

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie" wrote in
message ...
Okay, here is what I am trying to do, could someone tell me exactly and
specifically how to write it up and plug it into my macro? THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red entire
ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold entire
Row

Well that did what it was intending to do, but not what I meant I think.
What I'm trying to do is this:

IF the value in that column K is equal to 99 AND the value in column V is
equal to 0 then bold the entire ROW

IF the value in coulmn K is 13 - 98 OR greater than 100 then RED the entire
ROW

Unless I'm doing something wrong, the conditional formatting just does
individual cells throughout the document, at least when I typed it in that
way. I want the whole ROW to be red or bold based on the values of those
cells in the COLUMNS.

Thanks, you got me closer then I was previously :) I'll play around and
see if I can come up with it. Any other assistance is MUCH appreciated.
THANKS!!!

"Bob Phillips" wrote:

Use conditional formatting with a formula of

=OR(AND(K1=13,K1<=98),K1100)

and form at as red

second as

=OR(K1<13,K1=99)

and format as bold

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie" wrote in
message ...
Okay, here is what I am trying to do, could someone tell me exactly and
specifically how to write it up and plug it into my macro? THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red entire
ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold entire
Row

First, you need to select the whole row.

Then you should use absolute column references (my bad sorry).

So in all I think it is

=OR(AND($K1=13,$K1<=98),$K1100)

and

=AND($K1=99,$V22=0))


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie" wrote in
message ...
Well that did what it was intending to do, but not what I meant I think.
What I'm trying to do is this:

IF the value in that column K is equal to 99 AND the value in column V is
equal to 0 then bold the entire ROW

IF the value in coulmn K is 13 - 98 OR greater than 100 then RED the
entire
ROW

Unless I'm doing something wrong, the conditional formatting just does
individual cells throughout the document, at least when I typed it in that
way. I want the whole ROW to be red or bold based on the values of those
cells in the COLUMNS.

Thanks, you got me closer then I was previously :) I'll play around and
see if I can come up with it. Any other assistance is MUCH appreciated.
THANKS!!!

"Bob Phillips" wrote:

Use conditional formatting with a formula of

=OR(AND(K1=13,K1<=98),K1100)

and form at as red

second as

=OR(K1<13,K1=99)

and format as bold

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie"
wrote in
message ...
Okay, here is what I am trying to do, could someone tell me exactly
and
specifically how to write it up and plug it into my macro? THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red
entire
ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold
entire
Row

Something is off. Not exactly sure what, but that is even closer. :P

Not sure why, but this is what it highlighted in these selected rows testing
using these formulas.

ROW K V HIGHLIGHT

2 3 66 Red
3 99 0 Nothing
4 99 0 Bold
5 0 3 Bold

Can't really explain why it did that. So something is just still fuzzy


"Bob Phillips" wrote:

First, you need to select the whole row.

Then you should use absolute column references (my bad sorry).

So in all I think it is

=OR(AND($K1=13,$K1<=98),$K1100)

and

=AND($K1=99,$V22=0))


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie" wrote in
message ...
Well that did what it was intending to do, but not what I meant I think.
What I'm trying to do is this:

IF the value in that column K is equal to 99 AND the value in column V is
equal to 0 then bold the entire ROW

IF the value in coulmn K is 13 - 98 OR greater than 100 then RED the
entire
ROW

Unless I'm doing something wrong, the conditional formatting just does
individual cells throughout the document, at least when I typed it in that
way. I want the whole ROW to be red or bold based on the values of those
cells in the COLUMNS.

Thanks, you got me closer then I was previously :) I'll play around and
see if I can come up with it. Any other assistance is MUCH appreciated.
THANKS!!!

"Bob Phillips" wrote:

Use conditional formatting with a formula of

=OR(AND(K1=13,K1<=98),K1100)

and form at as red

second as

=OR(K1<13,K1=99)

and format as bold

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie"
wrote in
message ...
Okay, here is what I am trying to do, could someone tell me exactly
and
specifically how to write it up and plug it into my macro? THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red
entire
ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold
entire
Row

I think David got it, I got my columns and rows tangled

=AND($K1=99,$V1=0))


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie" wrote in
message ...
Something is off. Not exactly sure what, but that is even closer. :P

Not sure why, but this is what it highlighted in these selected rows
testing
using these formulas.

ROW K V HIGHLIGHT

2 3 66 Red
3 99 0 Nothing
4 99 0 Bold
5 0 3 Bold

Can't really explain why it did that. So something is just still fuzzy


"Bob Phillips" wrote:

First, you need to select the whole row.

Then you should use absolute column references (my bad sorry).

So in all I think it is

=OR(AND($K1=13,$K1<=98),$K1100)

and

=AND($K1=99,$V22=0))


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie"
wrote in
message ...
Well that did what it was intending to do, but not what I meant I
think.
What I'm trying to do is this:

IF the value in that column K is equal to 99 AND the value in column V
is
equal to 0 then bold the entire ROW

IF the value in coulmn K is 13 - 98 OR greater than 100 then RED the
entire
ROW

Unless I'm doing something wrong, the conditional formatting just does
individual cells throughout the document, at least when I typed it in
that
way. I want the whole ROW to be red or bold based on the values of
those
cells in the COLUMNS.

Thanks, you got me closer then I was previously :) I'll play around
and
see if I can come up with it. Any other assistance is MUCH
appreciated.
THANKS!!!

"Bob Phillips" wrote:

Use conditional formatting with a formula of

=OR(AND(K1=13,K1<=98),K1100)

and form at as red

second as

=OR(K1<13,K1=99)

and format as bold

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"bodhisatvaofboogie"
wrote in
message ...
Okay, here is what I am trying to do, could someone tell me
exactly
and
specifically how to write it up and plug it into my macro?
THANKS!!!

If Column 11 is equal to 13-98 then red entire ROW, 100+ then red
entire
ROW

If Column 11 is equal to 99 AND column 22 is equal to 0 Then Bold
entire
Row

"Bob Phillips" wrote in message
...
First, you need to select the whole row.

Then you should use absolute column references (my bad sorry).

So in all I think it is

=OR(AND($K1=13,$K1<=98),$K1100)

and

=AND($K1=99,$V22=0))

Did you mean $V22, or $V1?
--
David Biddulph

That is a good catch, I changed that, but the highlighting and bolding is
still off.

"David Biddulph" wrote:

"Bob Phillips" wrote in message
...
First, you need to select the whole row.

Then you should use absolute column references (my bad sorry).

So in all I think it is

=OR(AND($K1=13,$K1<=98),$K1100)

and

=AND($K1=99,$V22=0))

Did you mean $V22, or $V1?
--
David Biddulph