[Anwsered] conditional formatting across worksheets

conditional formatting across worksheets

I WOULD LIKE TO DO SOME CONDITIONAL FORMATTING BASED ON THE OUTCOME OF ANOTHER WORKBOOK.
I.E.
I WANT CELL A1 TO BECOME GREEN IS CELL A1 (ON ANOTHER WORKSHEET) IS 0, RED IF 100 AND AMBER IF BETWEEN 0 AND 100.
PLEASE HELP.

Keys to the Problem conditional formatting across worksheets

Download Error Fixer (Free)

And between workbooks, but changing the ranges to suit your needs:
1.
In the one workbook name the range containing the serial numbers, here I named it Data.  (highlight the range and choose Insert, Name, Define, type Data into the Names in workbook box and click OK).
2.
Move to the other workbook and in an empty cell type = and then click on any cell in the other workbook to build a formula like
'[10-21-2008.xls]Sheet2'!$A5
3.
Edit this formula so it reads
'[10-21-2008.xls]Sheet2'!Data
Press Enter and the formula will change to
='10-21-2008.xls'!Data
4.
Highlight the formula on the Formula Bar and copy it, press Enter once to escape the Formula Bar
5.
Choose the command Insert, Name, Define and enter a name like FSE1 in the Names in workbook box (if you are using 2007 make it four letter followed by a number to be on the safe side)
6.
Click in the Refers to box, clear the existing entry and choose Paste.  This should paste the formula from step 3 into the Refers to box.  Click OK.
7.
Select the range with your serial numbers say A1:A100 and choose Format, Conditional Formatting, Formula is from the first drop down, and in the second box enter =OR(A1=FSE1)  pick Format and choose what you want.  Click OK twice.

If this answer solves your problem, please check Mark as Answered.
If this answer helps, please click the Vote as Helpful button.
Cheers, Shane Devenshire

Because of this conditional formatting across worksheets error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error conditional formatting across worksheets can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve conditional formatting across worksheets error or repair the corrupted and damaged Windows files, you will need a conditional formatting across worksheets error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

1. Start the computer and log in as administrator
2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
4. On the new confirmation window that appears, click Next
5. Restart your computer after the restoration has been completed

Another Safe way to Repair the Problem: conditional formatting across worksheets:

How to Fix conditional formatting across worksheets with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Run it, and it will scan your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.

Related: Best Way to Download Satellite L645-SP4004M WinDVD BD for Toshiba v.10.0.6.110 driver,Download Toshiba Satellite C655D-S5057 Wireless LAN Driver v.8.0.0.258.0,Method to Update & Download Toshiba Satellite L650-BT2N22 Web Camera Application v.2.0.3.37 driver,How Can You Update & Download Toshiba Satellite L775D-S7220GR Value Added Package v.1.6.0130.640204 driver,Download Toshiba Satellite Pro L750-SP5176FM Sleep Utility v.1.4.0025.000101 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Fast Solution to Problem: computer shuts down and receive Windows Update error 800F020B,[Solution] Computer won't let me change defaults.,How to Fix - computer shuts down after a few minutes and when restarted I get windows has improperly shutdown.?,How Can You Fix - conditional formating - Excel 2007 and 2003 versions being used?,Fast Solution to Error: Computer Lock's up randomly, mostly during game play.,Can't change homegroup sharing permission,Can't connect XP shared printer to Win7 except as a local printer.__,Can You Connect the LAN Adapter for Wii On your Windows 7 Laptop?,Can These Files Be Deleted,Can’t install Microsoft Flight Simulator X Gold Edition error 1722