If Statement Help

B

bodhisatvaofboogie

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
 
B

Bob Phillips

Use conditional formatting with a formula of

=OR(AND(K1>=13,K1<=98),K1>100)

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)
 
B

bodhisatvaofboogie

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!!!
 
B

Bob Phillips

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),$K1>100)

and

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


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
B

bodhisatvaofboogie

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
 
D

David Biddulph

Bob Phillips said:
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),$K1>100)

and

=AND($K1=99,$V22=0))
Click to expand...

Did you mean $V22, or $V1?
 
B

bodhisatvaofboogie

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

Bob Phillips

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)
 
B

Bob Phillips

The other thing then could be that you didn't select row 1 first when you
added the formula.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
B

bodhisatvaofboogie

Nevermind, I got it figured out. I had started selecting from row 2, so when
I plugged in the formulas as row 1, it threw everything up one row. DOH!!!
*smacks forehead* Thanks a bunch guys, works great, HUGE help!!! :)
 
Top