highlighting the cells using conditional formatting

Hi!

Is it possible to highlight a1:h1 if cell a2 contains dark?

i used this code in cell i1-->=MATCH("dark",a2,0)

and i dont know what's next, my friend in the office told me to use conditional formatting but he's not sure, im confuse... someone?


Thanks...

Hi Dark,

1. Select cells A1:H1 and click Conditional Formatting on the Home ribbon.
2. Click New Rule, then select 'Use formula to determine which cells to format'
3. Use the following formula in the box provided: =ISNUMBER(FIND("dark",$A2))
4. Click the Format... button and select the formatting you want
5. Click OK twice to return to your sheet, and test the formatting.

That should do it!