[stoney]

Trying to write a conditional format, such that:

if $A26=$E$4, $A26:$E26 turn amber
if $A26/=$E$4, nothing happens

I need this for rows 26-54. Any ideas?

Killing myself trying to figure this out, and excel 07 sucks.

 

[DirtyMike]

Click the corner.... Drag it across all the rows you want it on.....

 

[stoney]

I'm trying to write a conditional formatting equation on an array... not what you're saying...

 

[binary visions]

No guru needed. Is easy.

Select the row you want to turn amber (not the whole row, just the cells you want to change). Home tab, select Conditional Formatting, Manage Rules. Create a new rule.

Select "Use a formula"

In the formula, box, enter "=$A$26=$E$4" and choose your formatting.

Profit.

 

[stoney]

tks. We figured it out at the office. I was just hoping to get it done last night.

 

[binary visions]

You didn't expect a few hour delay when posting a technical question on a mountain bike message board at 1:30am?