2003 vs. 2007 Color Conversion
My workbook started in Excel 2003, but is now working in Excel 2007. The below code is working so far as no errors is concerned; however, instead of background colors, I'm getting numbers in the cells. Looking around, I understand these are the new colors
for 2007. How do I get the cells to show the required colors instead of a number? The cells are formatted date.
Private Sub OptionButton5_Click()
If Range("X29") <> False Then
Range("AF29:AI29") = RGB(255, 255, 204)
Range("AD29:AN29") = RGB(255, 255, 204)
Range("AF31:AI31") = RGB(242, 242, 242)
Anwsers to the Problem 2003 vs. 2007 Color Conversion
Another problem, the colors are coming up correct; however, I'm also getting numbers, like 13434879 in the yellow cells, which are displayed as #########. How do I resolve this?
Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.
Make sure your computer has at least the minimum amount of random access memory (RAM) required to run the program that is displaying the error. Look for the program requirements online or in the packaging information.
Recommended Method to Repair the Problem: 2003 vs. 2007 Color Conversion:
How to Fix 2003 vs. 2007 Color Conversion with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will perform a scan for your system. The junk files will be shown in the list.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.
Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: 2010 word starter will not shut down,How to Fix Problem - 2010 Mail Merge?,2011 windows live messenger yüklenmiyor [Solved],Troubleshoot:2 Sided printing wont work with Homegroup Error,How Can You Fix - 2 programs are no longer giving me the window to save files or import files.?,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32