Thread: Change background colour of a row if a particular cell has a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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
Reply With QuoteReply With Quote