SOLVED

Conditional formating using a lookup formula.

Regular Contributor

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.

 

xlookup farge.PNG

 

Best Regards

- Geir

 

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

@Geir Hogstad 

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 @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