Coding

[Tennisguuy]

I have a worksheet that I would like to have excel highlight a row if a cell in that row is equal to a certain value. For example, if cell J23 is equal to Declined By-Field or Declined By-Und I want it to fill this row with the color Red. If J23 is equal to Quoted I want it to fill this row with the color Yellow and if J23 is equal to Sold I was it to color is Blue.

 

[VoG]

You could use Conditional Formatting http://www.contextures.com/xlCondFormat02.html

 

[JamesW]

Hi there,

Highlight the row and click on Format -> Conditional Formatting -> Formula Is:

=OR($J23="Declined By-Field",$J23="Declined By-Und") for Red
=$J23="Sold" for blue
=$J23="Quoted" for Yellow

 

[Tennisguuy]

How would I do this in excel 2007

 

[VoG]

On the Home tab, Conditional Formatting, New Rule, select Use a formula...

 

[Tennisguuy]

This is what I did and it's not working so I am not sure what I am doing incorrectly.

I highlighted cells A3:K500
I clicked on Conditional Formatting
I selected New Rule
I selected Use a formula to determine which sells to format
In the "Edit the Rule Description: I enter this formula =$J$3:$J$500="Declined-Field"
I clicked on the format button and selected my color then I click OK

However, nothing happened. The first time around I just used this formual =$J$3=Declined-Field" because this is the filed that the rule should be based on. However I have 500 rows in the workbook that I was this rule to work so I went back to change is to the above.

 

[VoG]

Highlight the cells, proceed as before but use the formula

=$J3="Declined-Field"

 

[Tennisguuy]

Thanks, that did it.