I am trying to create a rule to ensure that data in Column E (starting at E2) will match either Column F (F2) OR Column G (G2). I want the rule to apply from row 2 ongoing. There is an entry in either Column F or Column G but never both. For accounting purposes I want to be sure that Column E will be an exact match to Column F or Column G.
Here's a hypothetical Example
(column E) (column F) (column G)
(row 2) $2175.19 $2175.19
(row 3) $1445.22 $1445.22
Any suggestions? I would hate to have to verify each row manually if there were an accounting error at year end.
Thanks in advance.
Bookmarks