Hello Excel experts, I am a macro newbie, but I want to learn (but this time I do not have the time for that) so I turn to your wisdom instead and hope for the best
My problem is:
I have a column C which is conditionally formatted where there is text and also a color (blue) for some specific text content, otherwise the color is unformatted.
Now I want the column to the left (B) which also contains data (numbers) to have the same color as the cell in the C column. (If one cell in column C is blue, then I want the cell in the B column to also be blue).
How would I go about doing this?
Thank you for your help in advance