OK...I got the rows to highlight. Now I just realized that I want the row
to highlight under 2 conditions. The first condition is done...
=ISBLANK($P22)
What I really need to happen is the following:
If cell in Column P is blank AND the cell in Column J is greater than 0 the
I want the entire row to highlight. Is this possible? I attempted to place
another conditon in the conditional formatting but to no avail! Thanks in
advance!
--
Scott Hillis
Home Team Sporting Goods & Apparel
"Home Team Sporting Goods & Apparel" wrote in message
et...
Can somebody point in the right direction as to how to do the following:
I want the entire row to be highlighted yellow if the value in column P
(which is in the 00/00/00 date format) is blank. I have tried conditional
formating but can't seem to get it right. Thanks in advance.
Scott
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 6/23/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.710 / Virus Database: 466 - Release Date: 6/23/2004