Forum Discussion
Will a formula work in Conditional Formatting?
I have a spreadsheet with 2 pages. The first tab (master list) lists a person's username and the classes they have to complete. The second tab (completion report) lists usernames, the class ID an...
Maybe like in the attached file. In the first step i pulled the completion status to the master sheet with VLOOKUP. Then i referred to the completion status within the master sheet with 3 rules for conditional formatting.