Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
Hi, I just wondered if anyone knew if it was possible to copy and
paste a cells conditional formatting result with the actual formula that it was based upon. For example, Cell A1 has a CF that states that if the value is 5 or less then the cell will have a have a cell background color of yellow. What I wold like to do is to keep the cell BG color as yellow but remove the CF. Is that possible as I have a whole spreadsheet which has CF which I would like to keep without the formulas that set the CF in the first place. Hope that makes sense lol thanks in advance steve --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
Hi Steve,
Am Mon, 06 Jun 2016 20:08:58 +0100 schrieb steve: Hi, I just wondered if anyone knew if it was possible to copy and paste a cells conditional formatting result with the actual formula that it was based upon. For example, Cell A1 has a CF that states that if the value is 5 or less then the cell will have a have a cell background color of yellow. What I wold like to do is to keep the cell BG color as yellow but remove the CF. Is that possible as I have a whole spreadsheet which has CF which I would like to keep without the formulas that set the CF in the first place. a CF coloured cell has no *real colour*. You can check this in the VBA editor in the immediate window e.g. with: ?range("A1").Interior.ColorIndex That will show you -4142 that means xlnone. If you copy the range without CF the colour is gone. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |