David Underwood’s Professional Blog

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

reply

Thank you, but I’m asking specifically about conditional formatting.
ExcelObsesse posted on Friday, December 07, 2007 3:06 PM

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!

reply

That is the formula to use with the conditional format.
Luke posted on Friday, December 07, 2007 3:13 PM

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.

http://www.eggheadcafe.com/software/aspnet/31287951/conditional-formatting-fo.aspx