I have a spreadsheet which holds a shape “Rounded Rectangle 4”
Another cell (I34:L36) holds an IF formula which outputs either “Pass” “Fail” or remains blank
I would like to make this shape only appear when the word pass appears in the cell as a result of the formula
I am not very advanced with VBA so please make it as simple as possible. I have tried using multiple guides on google on how to achieve this but I cannot make it work
Thanks in advance