Conditional formatting in a formula
 

I have a spreadsheet which has conditional formatting (i.e. turn cell red if
values match criteria I have input). I want to create another sheet in this
spreadsheet which picks up values and formatting from the main sheet.

Example: Sheet 1, cell A1 value is 500 and the cell has conditional
formatting which turns the cell colour (not font) red. Sheet 2, cell B6 has
a format which is =Sheet1!A1

This shows the value of 500 but does not pick up the conditional formatting.
I've tried copying the format from a cell in sheet 1, and applying this to
selected cells in Sheet2, but of course the reference is wrong.

How do I create a formula that will pick up the formatting too?

Conditional formatting in a formula
 

Formulae return values to cells. They can't affect formatting.

Try applying the same CF to the cells in Sheet2.

In article ,
Annie1904 wrote:

I have a spreadsheet which has conditional formatting (i.e. turn cell red if
values match criteria I have input). I want to create another sheet in this
spreadsheet which picks up values and formatting from the main sheet.

Example: Sheet 1, cell A1 value is 500 and the cell has conditional
formatting which turns the cell colour (not font) red. Sheet 2, cell B6 has
a format which is =Sheet1!A1

This shows the value of 500 but does not pick up the conditional formatting.
I've tried copying the format from a cell in sheet 1, and applying this to
selected cells in Sheet2, but of course the reference is wrong.

How do I create a formula that will pick up the formatting too?