Conditional Formatting

D

dgee

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 - [email protected]
 
N

NBVC

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
Format
 
E

Eduardo

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