lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
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>