Forum Discussion
Solved
Conditional formating using a lookup formula.
Hi, I would like to use condiotional formating to colour an array ie the number ie below the value in a table. Tried several, but conditional formating using formula does not accept it. Like:...
Please don't us names (including tables names) In conditional formatting, formula shall be like
=O5<XLOOKUP($H5,$C$5:$C$15,$E$5:$E$15)
Please don't us names (including tables names) In conditional formatting, formula shall be like
=O5<XLOOKUP($H5,$C$5:$C$15,$E$5:$E$15)
Thank you SergeiBaklan It worked perfect. I made it more dynamic using a named range. That worked as well.
Best Regards
- Geir
Hogstad_Raadgivning , glad it helped