Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
Conditional Formatting 12
Need help with a formula 3
Question about the "Match" formula 3
VLookup 1st 9 char of Lookup range 11
Calculate working days but change working week 1
Formula result not displayin in cell 4
Setting cell format based on format codes 3

Back
Top