Wednesday, September 21, 2016

Troubleshoot:Conditional Formating one cell based on another cell's value

Conditional Formating one cell based on another cell's value

Ok.  I will first say that "normal" conditional formating is quite simple to learn, so this question is quite complex to me.
Here is the scenario:
In coulmn "B" I have set some conditions for the entire column such as:
If Cell = "N/A" the cell interior becomes gray with bold black font......
I have also used data validation in coulmn "B" to select from a drop-down list of text.  One of those is:
CM Open
What I am trying to do is format the "CM Open" in column "B" to turn green if it is less than or equal to the date in column "Z" AND turn red if "CM Open" is past the date in column "Z".
This, in theory anyway, sounds simple.  But I can't figure out how to write a VBA for this or use conditional formating, which I don't think will work in the first place.
The problem here is that Column "Z", the date I want to use to change the color of Column "B" is NOT static (constant), it will continually change.  So I cannot use the formula TODAY(), nor can I enter ONLY the column ($Z:$Z) as part of the statement because
the dates are different in each cell (Column Z, Row 5 is a different date than Column Z, Row 6).
Also, I want this to occur ONLY when column "B" states "CM Open", so I cannot use $B:$B as part of the statement either. 
I need a statement similar to this:
If column "Z" row "4"= (05-01-2014) then column B = green ONLY if column B = CM Open
If column "Z" row "4" = (05-05-2014) then column B = red ONLY if column B - CM Open 
The problem being that I only want the formula to use the date in the same row ONLY when column B has "CM Open" selected from the drop-down list

Is it possible to create a "one and done" formula like this?  So column "B" cells cahnge automatically when data is entered in column "Z"?????
I would REALLY REALLY like to create a script like this so I don't have to do it manually!!!

Can this be done?

Solutions to the Problem Conditional Formating one cell based on another cell's value

Download SmartPCFixer to Fix It (Free)

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Another Safe way to Repair the Problem: Conditional Formating one cell based on another cell's value:

How to Fix Conditional Formating one cell based on another cell's value with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. 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. driver,Download Toshiba Satellite C655D-S5057 Wireless LAN Driver v.,Method to Update & Download Toshiba Satellite L650-BT2N22 Web Camera Application v. 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.,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.,Method to Update & Download ASUS K41VD Intel INF Update Driver v.,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: Fast Solution to Problem: computer has become very slow...,Tech Support: computer locks up,Troubleshoot:Computer can't find the built in webcam,[Anwsered] computer will not go in to sleep mode,Conditional Header,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

No comments:

Post a Comment