Conditional formating an entire row?

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi there
I am looking to shade an entire row within a worksheet based upon the value
in the first column.
The first column contains days of the week, I want to shade the rows for all
Mondays, I can shade the first box (Monday ) using conditional formatting,
but I can not think how to shade the rest of the row.

Is this possible?

Thanks
Chris

Ps I'm still using MS office 97
 
Hi Chris,

Change the formula to reference the letter portion of the address
to absolute reference of the column.

The formula would be tested by each cell in the row so it must check
a specific column.

The cells that can be colored is based on the selection. The formula
is based on the active cell.

More information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
Thanks David that's Exactly what I needed


David McRitchie said:
Hi Chris,

Change the formula to reference the letter portion of the address
to absolute reference of the column.

The formula would be tested by each cell in the row so it must check
a specific column.

The cells that can be colored is based on the selection. The formula
is based on the active cell.

More information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
Click to expand...
 
Back
Top