Formatting New to Excel

[Imdabaum]

So I've used excel for my monthly family budget and what not, but now I need some real power... conditional formatting

I want to highlight an entire row if column $H$Z ="x" where Z is the row number.

I can get it to work for row 2 by setting the rule =$H$2 = "x". But was wondering if there was an easier way to make that format for every row in the spreadsheet.

[lucas]

code?

[Imdabaum]

code?

No code.. I highlighted the fields, hit the conditional formatting button, clicked new rule and it gave me a formula

For the formula I entered =$H$2 ="x" and applies to $A:G$. Formatting is just blacking out the entire row or in this case row 2. But ideally I would like it to work for $H(rowY) whatever the value of rowY is.

[mbarron]

In row 2, highlight the cells you want to conditionally format.
Use =$H2 ="x" as your formula
copy the cells in row 2
Highlight the rows you want to apply the formatting (eg rows 3 through 100)
Right click anywhere within the highlighted cells and choose Paste Special...
Choose Formats
Ok out

You have to make sure your row reference is Relative and not Absolute
$H2 <-Relative (no $ before the 2)
$H$2 <- Absolute ($ before the 2)

[Imdabaum]

Thanks. That explains it.

[mbarron]

Or you could highlight the entire range and apply the formatting at once using
=$H2 = "x"
as long as your current cell is in row 2.

Sorry for making it longer than it had to be.