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)
 
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

Conditional Formatting based on a cell value 4
Not working: Conditional Formatting 5
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional formatting, coloring the whole row 2
problem with formulas (2) 7
condition format 2
Excel Excel due and overdue date colours 2
'smart' dragging 2

Top