Conditional formatting based on text of another cell

**Cjax** · 07-30-2009, 02:42 PM

I would like to have cells in a certain column turn green if the word in column J of the corresponding row = Not Changed"

Thanks!

**martindwilson** · 07-30-2009, 02:46 PM

use conditional formattng see here
http://www.free-training-tutorial.co...ormatting.html

**Cjax** · 07-30-2009, 02:56 PM

Hi Martin - thanks the for the link but none of those examples exaplined what I'm looking for. Any other help would be appreciated. Thanks

**martindwilson** · 07-30-2009, 05:32 PM

follow the tutorial to show how to use a formula
but dont select those as shown select your range instead
say you want b2:b100 select that.
now instead of their formula put
=$J2="not changed"
including the quotes
(note same row as your first row in range so it lines up)
pick a format colour for cell then finish