Conditional formatting by comparing two fields with each other?
I see that conditional formatting is possible if a certain field fulfills a certain criteria i.e. contains certain data, is equal to certain data, etc.
But, I would like conditional formatting if my field #scoped devices is equal to my field #shipped devices.
I see that I can move or copy entire rows to another spreadsheet as part of the workflow feature. But I just want to format a row, when the job is completed.
Is that possible? Thanks so much.