Conditional formatting

R

RUSH2CROCHET

I'm relatively certain that a similar question has been answered previously,
but am in a pinch, and really can't take time to read a bunch of posts.
Hoping someone can help.

Spreadsheet A2:N56 = data about transactions (each row is a different
transaction)
Column L indicates "Shipping Date"
Column O =NETWORKDAYS(L2,$P$1)-1
P1=Today()

Desire to highlight entire row if O2:O56 is equal to or greater than 12.

All help appreciated!

TIA,
Sandi
 
M

Miguel Zapico

You can use conditional formating for this. Select the whole area (A2:O56),
go to Format->conditional formating, and insert the formula:
=($O2>=12)
Choose the highlight you want with the format button.

Hope this helps,
Miguel.
 
R

RUSH2CROCHET

Miguel:

You are a godsend.... Thanks so much! After departmental updates to the
data file, I actually have ended up with 251 transactions to calculate and
highlight.
I modified slightly to "calculate" each row, as column "L"-shipping date
varies per transaction.

I have conditionally formatted the entire range as Formula
Is=($O1:$O251>=12) as you indicated.
One quick question, however, For some reason, Row 250 is highlighted but
column "O" equals only "3" - thus conditional formatting would not apply?

Any ideas?

TIA,
Sandi
 
M

Miguel Zapico

Well, you don't need to hard-code the whole range in the conditional formula.
I have used absolute references only in the column, not the row, so if you
select the whole range (A1:O251) you can use the formula:
=($O1>=12)
Don't need to use the whole $O1:$O251 range, just use the first row that you
have selected. Try it, that may be the cause of the issue.

Miguel.
 
R

RUSH2CROCHET

Miguel:

Thanks once again! That was exactly what I needed. Come to find out, it
gives you a totally different result if you start your range selection from
cell O251:A2.....

Happy Wednesday!
LOL
Sandi
 
Top