Forum Discussion
Julio Rodriguez
Mar 13, 2018Copper Contributor
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 ...
Matt Mickle
Mar 13, 2018Bronze Contributor
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...