Check if a Cell is a Certain Color Using GET.CELL in Excel

[@MaureenPesch]

Thank you! I had seen the second option but not the first.

[@MyExcelOnline]

You’re welcome 😊

[@thejaswisr1064]

very helpful! thank you so much!

[@MyExcelOnline]

Glad it was helpful! You're welcome!

[@Dr.Khaled_Hassanein]

Thanks a lot for this video. Just a question: Does this work with conditional formatting ? Regards

[@MyExcelOnline]

Thank you for the question. No, I don't think it will work with conditional formatting.

[@kevinconley8786]

@@MyExcelOnline Could we build a formula like this using conditional formatting?

[@MyExcelOnline]

I don't think so because GET.CELL is a special kind of formula. Maybe if you set up GET.CELL and then use the formula that we put in the cell (put that in conditional formatting instead). That might work. Let us know if you try it and it does.

[@martyfouch3135]

Whenever I do it, I get the error #BLOCKED! What does that mean? I couldn't have been more exact following your instructions. Thanks.

[@MyExcelOnline]

That seems to be an issue with Excel. Here is a link from Microsoft for more info: support.microsoft.com/en-us/office/how-to-correct-a-blocked-error-13be117b-92e4-400a-a215-aa59d37d6e7c