Subform Conditional Formatting based on comparison between two fields (1 Viewer)

[Massoud]

Hi
I'm trying to find a way to highlight rows (or have different format from normal rows ) of my subform based on the value of two fields ( deb and cred fields ) If they are equal the normal formatting is used. If not, that specific row should have different forecolor ( or back color or etc.) from the other rows.
Is this possible in Datasheet view?

Thanks again

 

[Galaxiom]

Just needs an "Expression Is" setting in the ConditionalFormat. Right click on one of the controls and select Conditional Formatting. It is reasonbly self explanatory.

You can paste the formatting to the other controls once you get one of them working.