Conditional Formatting based on row value

EricKlasko

Hello Everyone,

I'm trying to color cell text in a table using a column rule. If the value in 2 rows is the same i would like the text colored green, if it is different then the text colored red. 

I've tried using this formula in the column rules but it just colors everything green : IF [RTO]=[RTO] Then "color:green" Else "color:red" ENDIF

Any assistance would be greatly appreciated. 

Thank you!

binu_acs

@EricKlasko another way of doing this with the multi-row tool

Table_03042025.yxmd