Hi all,
I am currently trying to improve a spreadsheet so that when entering a set of initials into columns D-J after all have been filled it will highlight a list of names in column A green to indicate it has been completed. My current formula
applies to =$A$2:$A$26HTML Code:
This achieves the desired cells to be filled green but i would like to reference a table with a list of initials that could replace the Y value to make this formula true. I am relatively new to conditional formatting and explored some =COUNTIF formulas but would appreciate any help from the Gurus!
Thank You,
Cameron
Bookmarks