Forum Discussion
need new formula
Hey there, looking for a formula I could use to where I have a spreadsheet of data where each project is in a different stage, and by clicking on the cell A6 it would highlight the cell in which the project is in.
1 Reply
You can use conditional formatting to achieve what you would like. Please review the attached file with an example of how to accomplish the task. If you don't have the option to use a conditional formatting formula you can use: Conditional Formatting > Highlight Cells > Text that contains to do something similar...
