Need to copy formatting when referencing a cell that is displayed using IF

[deborahlane]

I'm using Excel 14.7.7 for Mac.
iOS 10.12.6

I have six hidden columns and two unhidden columns. Depending on what is entered in a completely separate and different cell, I will copy the contents from two hidden columns to the unhidden ones. I also need to copy the formatting.

Is there a way to do this?

Here is the formula I am using to get the values from the hidden columns to the unhidden columns: =IF($A$49="Autumn",$AW2,IF($A$49="Spring",$AY2,IF($A$49="Summer",$BA2)))

(So I want the formatting from AW, AY or BA to end up in the cells, too.)

Thank you in advance.

[Pete_UK]

A formula can't be used to return formatting - it can only return a value to the cell in which the formula resides.

You may be able to use Conditional Formatting if the formatting depends on "Autumn", "Spring" etc.

Hope this helps.

Pete

[deborahlane]

A formula can't be used to return formatting - it can only return a value to the cell in which the formula resides.

You may be able to use Conditional Formatting if the formatting depends on "Autumn", "Spring" etc.

Hope this helps.

Pete

Thank you. The formatting that I need to copy is, in fact, conditional formatting. Does that help my cause?

[Pete_UK]

Yes, you can have 3 CF conditions, along the lines of what you are using already.

Hope this helps.

Pete