"Greying out" inactive rows

[glooft]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Hello. I am trying to figure out a method to automatically "grey out" or simply change the color of rows in my spreadsheet. I am creating a spreadsheet that keeps track of bidders in an auction-like sale. If someone refuses to raise their bid, they become inactive and do not receive any more phone calls. I was thinking that maybe I should have a column with an X in it to show that they are inactive. That would trigger some sort of conditional formatting to format the row as grey. Can anyone offer a more elegant solution?

 

[JE McGimpsey]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

Hello. I am trying to figure out a method to automatically "grey out" or
simply change the color of rows in my spreadsheet. I am creating a
spreadsheet that keeps track of bidders in an auction-like sale. If someone
refuses to raise their bid, they become inactive and do not receive any more
phone calls. I was thinking that maybe I should have a column with an X in it
to show that they are inactive. That would trigger some sort of conditional
formatting to format the row as grey. Can anyone offer a more elegant
solution?

That seems elegant to me, and very easy. If the "X" is in column J, say,
then select all the rows to be formatted (with, say, a cell in row 1
active) and use

CF1: Formula is =$J1="X"
Format1: <pattern>/<grey>

 

[glooft]

That seems elegant to me, and very easy. If the "X" is in column J, say,

then select all the rows to be formatted (with, say, a cell in row 1
active) and use

CF1: Formula is =$J1="X"
Format1: /

Thanks J. That works great. Since I'm new at Excel I've got to ask you if there is an easier way to apply this to 100 rows or do I need to apply conditional formatting individually to each row and change the formula from J1 to J2 to J3, etc...

 

[Phillip Jones]

Thanks J. That works great. Since I'm new at Excel I've got to ask you if there is an easier way to apply this to 100 rows or do I need to apply conditional formatting individually to each row and change the formula from J1 to J2 to J3, etc...

He just used J1 as an example.

first get the formula working for the particular column.

the if it not too many columns just click on the first cell associated
with that formula hold down option key and wait for grabber hand to
show up with a + sign inside. at that point drag to next cell that would
copy the formula based on the new position to that cell. Repeat as
needed. be sure to hold option key down first or you will end up adding
a cell rather than replacing empty cell contents with new formula.

You might highlight the entire column and try the auto sum button (looks
like a Z) but I don't use that often enough to say I prefer the option
drag and drop method.

Repeat entire procedure for each column as you are working with absolute
values (reason for the $ symbol) so dragging sideways won't work only
Dragging down might work.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[Phillip Jones]

PS:

If you get your formulas right then empty all the cells of number and
letters (NOT FORMULAS!) save the empty document as a Template then open
a copy of the template each time you need to create sheets for a new Day.

Thanks J. That works great. Since I'm new at Excel I've got to ask you if there is an easier way to apply this to 100 rows or do I need to apply conditional formatting individually to each row and change the formula from J1 to J2 to J3, etc...

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>

 

[JE McGimpsey]

Thanks J. That works great. Since I'm new at Excel I've got to ask you if
there is an easier way to apply this to 100 rows or do I need to apply
conditional formatting individually to each row and change the formula from
J1 to J2 to J3, etc...

No. Select all 100 rows. In your CF formula, use the row number of
whichever row has the active cell, e.g., if you select row 4:103 and the
active cell, listed in the Name box on the formula bar, is D7, then use

CF1: Formula is =$J7="X"

XL will then change the row number for each row.