Forum Discussion
Excel - Change cell format based on another cell format
Is there any way to change a cell format, based on another cell FORMAT (not value). For example - a color is added to one cell will change the color of another cell (or font, etc).
You can probably do it with VBA, but I cant think of a way to do it via normal conditional formatting.
Is there a reason you can't use the values?
Thanks, Philip for your prompt response.
To be more precise, I want to copy both the value, and the format.
VBA is not really an option in this case.
I will take this from here.
Thanks,
Roni