Conditional formating using a lookup formula.

Regular Contributor



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.


xlookup farge.PNG


Best Regards

- Geir


3 Replies
best response confirmed by Geir Hogstad (Regular Contributor)

@Geir Hogstad 

Please don't us names (including tables names) In conditional formatting, formula shall be like



Thank you @Sergei Baklan It worked perfect. I made it more dynamic using a named range. That worked as well.


Best Regards

- Geir

@Geir Hogstad , glad it helped