hey guys,
just wondering if for example cell a3 has a number it in it highlights the whole row 1 .. i tried conditional formatting but i cant seem to find it in there. any other ideas ?
Thanks!
matt
quick excel question
-
ColdFusion
- Posts: 3542
- Joined: Mon Oct 30, 2000 12:00 am
- Location: Vancouver, BC
-
mwkirchner
- Senior Member
- Posts: 4231
- Joined: Sun Sep 01, 2002 7:47 pm
- Location: Smyrna, Delaware Car: 1998 Honda Accord EX Occupation: Honda Service Coordinator
Can you try to explain this a little better? Does not really make sense no matter how many times I have read it.
Antec Nine Hundred case, 4GB A-Data DDR2 800 RAM, Intel Core 2 Duo E6750 Conroe 2.66GHz, ASUS P5K-E/WIFI-AP MB, XFX GeForce 8600GT XXX 256MB 128-bit GDDR3 video card, ZALMAN CNPS9500 AT 2 Ball CPU Cooling Fan/Heatsink, Seagate Barracuda 320GB 7200 RPM SATA 3.0Gb/s HDD, Aerocool FP-01 Multifunction panel w/card reader, Zerodba 620W PSU, LITE-ON 20X DVD±R DVD with LightScribe SATA, Samsung CDDVDW SH-S203B SATA, Acer P241W 24" w/s monitor, Canon CanoScan LiDE 35 scanner, Klipsch ProMedia 2.1.
-
mwkirchner
- Senior Member
- Posts: 4231
- Joined: Sun Sep 01, 2002 7:47 pm
- Location: Smyrna, Delaware Car: 1998 Honda Accord EX Occupation: Honda Service Coordinator
Originally posted by Shilly
Whaaat?
My feelings exactly
Antec Nine Hundred case, 4GB A-Data DDR2 800 RAM, Intel Core 2 Duo E6750 Conroe 2.66GHz, ASUS P5K-E/WIFI-AP MB, XFX GeForce 8600GT XXX 256MB 128-bit GDDR3 video card, ZALMAN CNPS9500 AT 2 Ball CPU Cooling Fan/Heatsink, Seagate Barracuda 320GB 7200 RPM SATA 3.0Gb/s HDD, Aerocool FP-01 Multifunction panel w/card reader, Zerodba 620W PSU, LITE-ON 20X DVD±R DVD with LightScribe SATA, Samsung CDDVDW SH-S203B SATA, Acer P241W 24" w/s monitor, Canon CanoScan LiDE 35 scanner, Klipsch ProMedia 2.1.
I think what he wants to do is to highligt a complete row if the corresponding cell in a column for that row is not null.
Just a little VBA should do that. Although I don't know the exact syntax. I usually don't work in Excel.
Something like (but just making this up)
Function highlightrow(C as string, R as string)
Dim strC as string 'column reference
Dim strR as string 'row reference
If not isnull(c,a) then
Highlight the row
end if
Sorry, it's been a long time since I had to do this. hehe
Just a little VBA should do that. Although I don't know the exact syntax. I usually don't work in Excel.
Something like (but just making this up)
Function highlightrow(C as string, R as string)
Dim strC as string 'column reference
Dim strR as string 'row reference
If not isnull(c,a) then
Highlight the row
end if
Sorry, it's been a long time since I had to do this. hehe