Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Formula | Excel Worksheet Functions | |||
Conditional formatting is set with a formula, but now I need to ch | Excel Discussion (Misc queries) | |||
Conditional formatting and formula | Excel Worksheet Functions | |||
conditional formatting or formula | Excel Worksheet Functions | |||
Conditional Formatting Formula | New Users to Excel |