|
If Statement Help
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 |
If Statement Help
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 |
If Statement Help
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 |
If Statement Help
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 |
If Statement Help
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 |
If Statement Help
"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 |
If Statement Help
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 |
If Statement Help
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 |
If Statement Help
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) "bodhisatvaofboogie" wrote in message ... 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 |
If Statement Help
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!!! :) "bodhisatvaofboogie" wrote: 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 |
| All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com