Wednesday, September 21, 2016

Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't)

Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't)

When using conditional formatting for a specific cell things work fine.  When using for a range (matrix) they sometimes work fine.  WHen using for a row or column (in this case) it doesn't work.
Column E has some cells with "Yes" (no quotes...
just the letters).
It is desired to set any row of 15 to 50 to a Yellow fill IF Eii="Yes", where ii is the row # from 15 to 50.  That is, if E15="Yes" (has Yes in it), then the entire row would be set to Yellow fill.  If E15 did not have Yes, then no change (no color).
Some rows have Yes and some may not.  For example, row 16's E16 could be blank and hence no Yellow fill.  Row 17's could also be blank (same result).  Row 18 (E18) could have a Yes and hence the entire row would be Yellow filled.  "Yes" is an indicator if
something is true (like have you been to Hawaii or whatever).
I can get this to occur cell-by-cell but whenever I select the entire row on the left of the Excel 2007 spreadsheet and set =E15="Yes" and then select the Yellow fill color I get nothing.  Same for =$E$15="Yes" or even =$E15="Yes".  I've tried and range
(=E15:E20="Yes") and I don't get the Yellow fill.  Doing each cell one-at-a-time works.  ;-(
What's the nuance here?
TIA!

Solutions to the Problem Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't)

Download Error Fixer (Free)

Select the entire range to which you want to apply the conditional formatting.
Note the address of the active cell within the selection, let's say it is A1.
This is important!
Activate the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select "Use a formula to determine which cells to format".
Enter the following formula into the box:
=$E1="Yes"
where 1 is the row number of the active cell.
If the active cell within the selection is B23, use
=$E23="Yes"
etc.
Click Format..., specify yellow fill color, and click OK twice.

Manually editing the Windows registry

Caution: Unless you an advanced PC user, please do not edit the Windows registry manually.

Because of this risk, we highly recommend using a trusted registry cleaner such as SmartPCFixer Using a registry cleaner automates the process of finding invalid registry entries, missing file references (like the one causing your MACHINE_CHECK_EXCEPTION error), and broken links within the registry. A backup is automatically created before each scan, with the ability to undo any changes in a single click, protecting you against the possibility of PC damage. The best part is that repairing registry errors can also dramatically improve system speed and performance.

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

The next steps in manually editing your registry will not be discussed in this article due to the high risk of damaging your system. If you would like to learn more about manual registry editing, please see the links below.

Recommended Method to Fix the Problem: Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't):

How to Fix Conditional Formatting: Values in ANOTHER cell in same row to display a color (works cell-by-cell otherwise it doesn't) with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

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

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


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: How to Resolve - Connecting to WI FI internationally.?,[Solved] Conditional Formatting - I already have 2 conditions based on the result of the cell content; however, I want the format to be different if a cell in another column is equal to Yes,Solution to Error: Computer restarts while I shut down in Windows 8,Fast Solution to Error: Computers on the LAN do not get the gateway and the DNS servers from DHCP server.,[Solved] Computer's performance issue- Internet Explorer and Office 365.,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