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:
=XLOOKUP(H5;T_faste[Din kodeliste];T_faste[Number];"")<I5
Colours here is manually adjusted, as an example.
Best Regards
- Geir
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)
3 Replies
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
