Fill Color based on Evaluation

**CoachBarker** · 06-15-2010, 09:32 AM

I have the following in a cell

=IF(OR(K2=I2, K2>I2),"Complete","")

If this is true and the cell contains Complete I want to fill the range A2:S2 with a color instead of being no fill. Is this doable?

**Marcol** · 06-15-2010, 09:46 AM

Try conditional formatting

Highlight A2:S2

Formula is ($D2 = your cell that returns "Complete")

=$D2="Complete"

Applies to

=$A2:$S2

Your formatting

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

**CoachBarker** · 06-16-2010, 06:21 AM

Sorry to jump back. This works for 1 row, but I can't figure out how to apply it to Row 2 thru Row 55. Do I have to do the same conditional formatting for each individual row?

Sorry again, I had the wrong formula in the rest of the cells for the formatting, changed that and now it works.