Question

Conditional Formatting


Userlevel 1
Badge +2

Is there a way to change the row colour if two columns dont match? 
for instance if the part UOM and the Purch UOM are different then colour the row red?

 

Thanks 


3 replies

Userlevel 7
Badge +18

Please follow the steps as mentioned in the below community thread.
it mentioned to change the cell color (not the full row)
But hope it helps.
Conditional Formatting Question | IFS Community

 

Userlevel 7
Badge +22

Hi @ZWELROBERTS 

that is not possible in my opinion.

Maybe you can create a custom field. For example: If part UOM and and purch UOM match, then set a flag in your custom field. 

Then use a conditional format on the custom field, you have created.

 

Userlevel 5
Badge +7

you can archive this by setting up a conditional formatting rule using the custom field.

Reply