I am going crazy on this. If the value of cell g5 = Overdue, then I want the
background for the entire row 5 to be red. I figured out how to get the cell
g5 red but not how to get the whole row

Thanks -

Select the entire row and re-invoke Conditional Formatting..

choose Formula is from 1st drop down and enter formula: =$G5="Overdue"

This condition can be copied to other rows via Copy | Paste Special |
Formats


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122783

Hi,
Highlight the row, then in conditional formating, where the formula is enter
$G$5="Overdue", choose border and color

"dgee" wrote:

I am going crazy on this. If the value of cell g5 = Overdue, then I want the
background for the entire row 5 to be red. I figured out how to get the cell
g5 red but not how to get the whole row

Thanks -