FantasyFootballFreak
New Member
- Joined
- Aug 22, 2007
- Messages
- 4
I am attempting to run a macro that will make conditional formatting I have applied permanent, and then remove the conditional formatting from the cell. My application for this is a master fantasy football cheatsheet, with multiple columns of the same player names ranked in different orders. When a player is drafted I type their name in cell A1, and conditional formatting is setup on all cells with names such that all cells containing that name (presumably once in each column) will be highlighted/bolded/etc. For example, if I typed "LaDainian Tomlinson" in cell A1, I would be able to find his name in each list/column (from the conditional formatting that will make it stand out), and then run the macro to make this formatting permanent (show he has been drafted), and remove the conditional formatting code, leaving the effects. I found a macro online to do this at the following link, but am having some issues:
http://exceltips.vitalnews.com/Pages/T0082_Removing_Conditional_Formats_but_Not_the_Effects.html
When I run the macro on any cells not containing conditional formatting, I get the message: "The formatting based on the conditions in the range (whatever is highlighted) has been made standard for those cells and the conditional formatting has been removed."
This messsage is precisely what I am trying to do, however, when I run the macro on a cell with conditional formatting (when it would actually be beneficial), I get "Run-time error '13' Type Mismatch"
When I go to debug, the error appears to be on the line "If CDbl(rng.Value) = CDbl(FC.Formula1) Then"
I am using Excel 2003, and unsure how to proceed. I would be the Fantasy Football king if I could get this macro to work. Can anyone solve the mystery?
http://exceltips.vitalnews.com/Pages/T0082_Removing_Conditional_Formats_but_Not_the_Effects.html
When I run the macro on any cells not containing conditional formatting, I get the message: "The formatting based on the conditions in the range (whatever is highlighted) has been made standard for those cells and the conditional formatting has been removed."
This messsage is precisely what I am trying to do, however, when I run the macro on a cell with conditional formatting (when it would actually be beneficial), I get "Run-time error '13' Type Mismatch"
When I go to debug, the error appears to be on the line "If CDbl(rng.Value) = CDbl(FC.Formula1) Then"
I am using Excel 2003, and unsure how to proceed. I would be the Fantasy Football king if I could get this macro to work. Can anyone solve the mystery?