Hi,
I'm creatting a macro to Remove Conditional Formats and the Effects
then change The color based on the Conditions to another standard color
it's working perfectlyHTML Code:
but now , I'm trying to Remove Conditional Formats but not the Effects
I have tried several ways, but either I get errors or no errors, but always not working
I wonder whether someone could help me
Thanks in advance !
Mokhtar
The strategy is to evaluate each condition against each cell, and then apply permanent formatting based on the rule. To make this general purpose to apply to all possible types of CF rules would be very complex, tantamount to reimplementing Excel's CF feature. If you have a very specific set of rules known in advance, it becomes easier.
What can you tell us about how you are going to use this code, how the worksheet is set up, and what are the conditional formatting rules in use?
Thanks for the reply mr.6StringJazzer
the conditional formatting rules is : use a formula to deterimine which cells to formate
format values where this formula is true : =cell_has_formula
show formatting for : current Selection
format cells : font style and fill background
Thanks
=cell_has_formula
There is no such function built in. How is this defined?
it's refers to
=GET.CELL(48;INDIRECT("rc";FALSE))
Last edited by mokht; 11-03-2015 at 03:47 PM.
Not for nuthin', but "CTRL + ~"(tilde) will easily identify which cells contain formulas. Repeat to view as normal.
Pete
cells contain formulas $A$1;$C$2;$A$3;$C$4;$A$5;$C$6;$A$7;$C$8;$A$9;$C$10
this is my excel file
Last edited by mokht; 11-03-2015 at 04:07 PM.
hiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
Any suggestions
what about this solution :
copy WorkRng , paste data into a new Word document Object , then copy it
Switch back to Excel Worksheet , delete rule from WorkRng , paste new data
is not agood idea ?
Anyone interested in giving me a hand with this?
Last edited by mokht; 11-04-2015 at 09:13 AM.
Hi
this is my solution :
it's working perfectly but i have a one problem , formulas in rane A1:C10 changed to valuesHTML Code:
Any help will be greatly appreciated.
Hope it is clear now
solved
here is first code
HTML Code:
here is the second
HTML Code:
Last edited by mokht; 11-05-2015 at 11:46 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks