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 - (e-mail address removed)
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 conditional formatting not playing ball 5
Changing row background from external program 0
Mail Merge Help 1
Conditional Formatting based on a cell value 4
Cobditional Formatting Rows based on dates in action plan. 0
Not working: Conditional Formatting 6
Conditional formatting with dates 7
Conditional formatting, coloring the whole row 2

Top