Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formatting
Hi, I'm using Excel 2007 and I'm using conditional formatting to highlight
duplicate cells. This works great. The only problem is, this is a huge spreadsheet, and the conditional formatting seems to really slow down of scrolling through the worksheet. I was really hoping to be able to convert the conditional formatting to "regular" formatting, meaning I would like to keep the color of the cell and/or the text and remove the "conditional" part that seems to be slowing everything down, but this doesn't seem possible. I tried to copy and paste the data into Word, thinking that I could then copy and paste it back into Excel, but the whole thing is so huge that it just hangs when I'm trying to paste into Word. If it isn't possible or easy to convert the conditional formatting to regular formatting, is it at least possible to "Go to" or "Find" each cell with conditional formatting so I could at least move quickly from one cell to the next and see where the duplicates are? My attempts to do this so far have failed. I don't work with conditional formatting much so maybe there's a simple solution that I'm missing. Thanks in advance for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formatting
Hi,
F5 Special Conditional Formating will allow you to select all your cells in one go .... to copy paste special ... HTH |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formatting
Hi, thanks for your reply. I tried what you suggested but whenever I try to
paste special all the formatting disappears unless I do a regular paste or choose "All" from the paste special menu. But if I do the latter then the formatting applied is still conditional formatting. Is there something else I have to do to get it to work? I think I've tried all the options in the paste special box. Thanks for any help. "Carim" wrote: Hi, F5 Special Conditional Formating will allow you to select all your cells in one go .... to copy paste special ... HTH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formatting
Sorry ... I read your initial post too quickly ...
You are facing quite a tricky issue ... Keep format generated by conditional formatting while deleting conditional formatting rules ... A good starting point would be Chip's site : http://www.cpearson.com/excel/CFColors.htm HTH |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formatting
Hi, thanks for the link. There seems to be a lot of good information on that
site. I tried using some of the conditional formatting functions listed there, but I can't seem to get them to work right. I've mostly been trying to use the COLOROFCF function but when I do, sometimes I get #NAME? errors, sometimes I get #VALUE! errors, and sometimes I do get a number, but I don't think it's correct because it gives the same number to cells both with and without conditional formatting. I guess maybe there is no easy answer to this. I'm just kind of puzzled because I keep getting so many different results whenever I try to use these functions. "Carim" wrote: Sorry ... I read your initial post too quickly ... You are facing quite a tricky issue ... Keep format generated by conditional formatting while deleting conditional formatting rules ... A good starting point would be Chip's site : http://www.cpearson.com/excel/CFColors.htm HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional formatting | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |