Forum Discussion
Solved
Change the cell color base on IF value
Hi Expert How can I create an excel formula for below condition Condition Day Unit Sunday 10 Monday 20 Tuesday 30 Wednesday 40 Thursday 50 Friday 60 Saturday ...
anwarsafian added the following CF rule to your file.
=B13<XLOOKUP(A13,$A$3:$A$9,$B$3:$B$9)See attached. If you have an older version of Excel you can achieve something similar with VLOOKUP. That would be:
=B13<VLOOKUP(A13,$A$3:$B$9,2,0)
anwarsafian added the following CF rule to your file.
=B13<XLOOKUP(A13,$A$3:$A$9,$B$3:$B$9)
See attached. If you have an older version of Excel you can achieve something similar with VLOOKUP. That would be:
=B13<VLOOKUP(A13,$A$3:$B$9,2,0)