Conditional Formatting

[Cer]

Is there a way to format an entire column or row based
upon the results in one column (e.g., If contents in any
of the cells in column A = Y, then highlight the entire
row)?

Thanks

 

[Don Guillett]

format>conditional formatting should do this.
Select the row NUMBER
format>conditional formatting
formula is =$a$5="Y"
format as desired

 

[David McRitchie]

formula is:
=COUNTIF($A:$A,"Y")
since you asked for a "Y" anywhere in one column.
This is a worksheet formula and is not case sensitive.

Select the column you want colored,
the formula is based on the active cell, but since
the formula is absolute it won't matter what the active cell is.

More information on Conditional Formatting in
http://www.mvps.org/dmcritchie/excel/condfmt.htm

More information on COUNTIF see HELP and
COUNT, Tip 52:Cell Counting Techniques
http://www.j-walk.com/ss/excel/tips/tip52.htm