Microsoft Excel help...conditional formatting?

[CantDog]

So I'm trying to organize a data set, and wanted to highlight an entire row each time a specified value appears in one column. For example, everytime 'TRUE' appears in column D, I want to highlight that entire row.

I figured out how to highlight just the cell in question, but cant get it to highlight the entire row, any suggestions? I used the conditional formatting tool to get to where I am now.

[stump832]

Write a macro, son.

[golden powder]

highlight entire first row, use "=+IF($D1=TRUE,TRUE,FALSE)" in the conditional formatting formula. copy format to all rows you want formatted.

[Fuzz]

In the conditional format box, set "Formula is" and then write the condition: "=$D10=TRUE". Then copy that cell's format (Copy > Paste Special > Formats) to the cells you want that conditional format to apply.

[smmokan]

And you call me a fucking idiot.

[TomK]

In the conditional format box, set "Formula is" and then write the condition: "=$D10=TRUE". Then copy that cell's format (Copy > Paste Special > Formats) to the cells you want that conditional format to apply.

Oh so close.
Select cell D10 first, and condtionally format it, just leave the quotemarks out of the condition Fuzz gave. =$D10=TRUE


FYI, $D means always look at column D. $D$10 would mean always look at cell D10. D10 would always look at whatever cell, just like the "cell value is" condition.

[Fuzz]

^^^ Actually, you don't have to select cell D10 first to write in the conditional format -- you can select any cell on row 10 and just copy that format over anywhere else.

Also, TomK is correct -- leave out the quotation marks around =$D10=TRUE. I put the quotes simply to show the exact entry.

[TomK]

^^^ Actually, you don't have to select cell D10 first to write in the conditional format -- you can select any cell on row 10 and just copy that format over anywhere else.

Also, TomK is correct -- leave out the quotation marks around =$D10=TRUE. I put the quotes simply to show the exact entry.

By selecting D10 first, it will give him immediate feedback that the conditional formatting has worked (as long as D10 has TRUE in it of course).
It's a teaching thing, that's all.

[gg8983]

Since you are dickwaving over conditional formatting, how about helping me with this one.

I need to do case sensitive vlookups. I have tried using =if(exact... but have not gotten it consistantly right.

[avacadotoast]

I would just sort the data set by the field in question - then highlight all or those rows that have that field (since they are all now right next to each other it's easy) - then sort the data back the way it was. Takes a couple seconds.

That macro and conditional formatting stuff is pretty fancy though.

[stump832]

Since you are dickwaving over conditional formatting, how about helping me with this one.

I need to do case sensitive vlookups. I have tried using =if(exact... but have not gotten it consistantly right.

http://www.ozgrid.com/forum/showthread.php?p=136839

sidenote: awesome 3000th post.

[Art Shirk]

[TomK]

[QUOTE=Corky;1320283]I would just sort the data set by the field in question - then highlight all or those rows that have that field (since they are all now right next to each other it's easy) - then sort the data back the way it was. Takes a couple seconds.

[QUOTE]

That's a good approach for a one-time finding, but the conditional formatting will work better if his data set expands or the content of the D cells change over time.