If it does, that cell gets highlighted, else it doesn’t. So when it’s analyzing each cell in row A2, it will check whether the cell C2 has the name Bob or not. This will highlight all the rows where the name of the Sales Rep is ‘Bob’.Ĭlick here to download the Example file and follow along.Ĭonditional Formatting checks each cell for the condition we have specified, which is =$C2=”Bob”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |