Quantcast

Excel 2007 guru help needed

stoney

Part of the unwashed, middle-American horde
Jul 26, 2006
21,761
7,487
Colorado
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.:rant:
 

stoney

Part of the unwashed, middle-American horde
Jul 26, 2006
21,761
7,487
Colorado
I'm trying to write a conditional formatting equation on an array... not what you're saying...
 

binary visions

The voice of reason
Jun 13, 2002
22,116
1,183
NC
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

Part of the unwashed, middle-American horde
Jul 26, 2006
21,761
7,487
Colorado
tks. We figured it out at the office. I was just hoping to get it done last night.
 

binary visions

The voice of reason
Jun 13, 2002
22,116
1,183
NC
You didn't expect a few hour delay when posting a technical question on a mountain bike message board at 1:30am? :D