Conditional Formatting

C

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
 
D

Don Guillett

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

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
 
Top