Change background colour of a row if a particular cell has a value

W

wolfey

Change background colour of a row if a particular cell has a value greater
than zero
 
J

Jacob Skaria

The below will change the background color of row to red if value in A1 is
greater than 5

1. Select the Row / rows
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=$A1>5
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
 

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

Highlighting cell on value difference. 1
colour change as a result of a figure 1
Conditional Formatting 12
Remove colour change 4
colour of a row depending on cell value 6
Conditional Formatting of a Row 2
Conditional Formatting - Excel 2003 2
change background row color with change of date in a cell 5

Top