Skip to main content
Question

Conditional Formatting

  • May 12, 2022
  • 3 replies
  • 847 views

Forum|alt.badge.img+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

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+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

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • May 13, 2022

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.

 


RanukaSerasinghe
Hero (Partner)
Forum|alt.badge.img+7

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