In MS Excel, what is a formula to test if a cell in a range has the color red? I don't know if this makes a difference. But if the cell is red, it will be so by conditional formatting.
I am testing for red background color, and if it is present in any cell in a given range, then I want another cell to also change to red.
Say, if any cells in range G12:G45 are red then cell A1 must also turn red. I want to use conditional formatting for A1. All Cells in G12:G45 also have a conditional formatting to turn red if certain criteria are met. I don't know the color index number for the red that is used. Perhaps there is a way to find out.
I’m Rachel, and I’m moderator for this topic. It seems the professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.
I was checking to see if you had already found your answer or if you still needing assistance from another one of the professionals? Please let me know if you wish to continue waiting or if you would like for us to close your question. Also remember that JustAnswer has a multitude of categories to help you with all your needs from Health, Pets, Computers, Taxes, Cars, Finance, Law, to Home Improvement, and more.