vlookup + formatting

[lezawang]

Hi

I wrote vlookup function + match function to return the value if a user enter name and month

A1= please enter name
A2= Please enter month

A3= vlookup (?,?:?,match(?,?,exact),false)

Everything is fine, if user enter Mary and month is Feb then the vllookup will return 22. My question, how can I make excel highlight 22 in the table in green color for example? Is that possible? Thank you so much.

name	jan	feb	mar	apr
john	1	2	3	5
mary	11	22	54	88
alex	8	4	33	2
liz	1	4	9	44

<tbody>
</tbody>

 

[baitmaster]

Conditional formatting, using a Formula to identify where the condition is met. Try writing the formula outside of Conditional Formatting until you get it right, then copy it in. A formula that might work would be:

=AND(A1=[mary],A2=[feb])

where [mary] and [feb] are the cells containing those values. You'll need to understand the use of $ in cell references to apply the conditional format formula to all cells, this particular CF would be applied to the cell containing 22, and would vary when copied to other cells so the rows & columns would need to be locked correctly to let this happen