Conditional formatting for rows

I'm familiar with conditional formatting, but cannot figure out the formula
to highlight an entire row based on the contents in one cell. For example,
for every cell in column G that contains the word "visa", I would like that
entire corresponding row to be highlighted. Can anyone tell me the formula?
Thanks!

Conditional formatting for rows

Formula is: =IF($G1="visa",true,false)
Do this somewhere in row 1, then copy the format everywhere you need it. The
$ sign locks the formula on column G, while the row number is floating.
--
Best Regards,

Luke M

Thank you, but I'm asking specifically about conditional formatting.

Thank you, but I'm asking specifically about conditional formatting. So,
going into format --> conditional formatting,  I need to enter a formula to
automatically highlight the entire row rather than just the individual cell.
Thoughts? Thanks again!

That is the formula to use with the conditional format.

That is the formula to use with the conditional format. You can copy
conditional formats from one cell to another.

Once you have the conditional format in once cell, copy, then select desired
area(or all, with Ctrl+A) to be affected, and right-click, paste special.
Choose format.
--
Best Regards,

Luke M

That worked!

That worked! I was trying to format the whole range at once, but pasting
special as the format fixed that. Thanks!!

Glad it worked!

Glad it worked! Thanks for the feedback.
--
Best Regards,

Luke M

Highlight row 2 by clicking on the row identifier, then click onFormat |

Highlight row 2 by clicking on the row identifier, then click on
Format | Conditional formatting, select Formula Is rather than Cell
Value Is and enter this formula:

=ISNUMBER(SEARCH("visa",$G2))

Then click on the Format button, select the Patterns tab and choose
your background colour. OK your way out. With row2 still highlighted,
double-click the Format Painter icon, then click in A3, A4, A5 etc for
all the rows that you want this effect to apply to - press <Esc> when
you are done.

Hope this helps.

Pete

On Dec 7, 8:06 pm, ExcelObsessed

Conditional formatting for rows

You could simply select Column G then Format>CF>Cell Value is: Equal to "visa"
without the IF, TRUE, FALSE formula.

Or simply Formula is:  =$G1="visa"

Also without using the format painter.


Gord Dibben  MS Excel MVP

On Fri, 7 Dec 2007 12:20:01 -0800, ExcelObsessed