ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/162345-conditional-formatting.html)

Sandy

Conditional Formatting

I need a formula for conditional formatting... that will compare the value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value

Sandy

Conditional Formatting

Mistakenly posted in this forum----reposting to worksheet functions

"Sandy" wrote:

I need a formula for conditional formatting... that will compare the value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value

All times are GMT +1. The time now is 07:08 PM.