View Full Version : [SOLVED:] Formatting New to Excel
Imdabaum
01-20-2010, 01:25 PM
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
01-20-2010, 01:43 PM
code?
Imdabaum
01-20-2010, 01:50 PM
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
01-20-2010, 01:50 PM
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
01-20-2010, 01:54 PM
Thanks. That explains it.
mbarron
01-20-2010, 01:54 PM
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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.