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

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

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

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 FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=$A15
4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"wolfey" wrote:

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