You could simply select Column G then FormatCFCell 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
wrote:

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

"Luke M" wrote:

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


"ExcelObsessed" wrote:

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!

"Luke M" wrote:

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


"ExcelObsessed" wrote:

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!