Conditional formating in Excel 2007

**tkuia** · 03-25-2009, 04:50 PM

How do I format the all line using data in one cell?
I new to do it in Excel 2003 but in 2007 I can do only "fancy" formating, but can't find the good old conditional formating.
Tnx!

**NBVC** · 03-25-2009, 04:57 PM

From the Conditional Formatting menu, select New Rule and then select Use a formula to determine which cells to format... the rest is pretty much like in 2003

**tkuia** · 03-26-2009, 02:00 PM

Thank you but I still can't format a line according to one cell.

I am choosing line 3.
Conditional formating -> new rule
Format all sells...
2-color scale
Type: formula
What should I putt in the formula in order to choose different color per
what a3 have?

Thank's!

**NBVC** · 03-26-2009, 02:10 PM

When you click New Rule, first select the last rule type from the top section (i.e. "use a formula to determine which cells to format"

Once you select that, then you can enter a formula, e.g. =$A3="X"

adjust formula to what you need.