applying conditional formatting to additional cells
I have a conditional format rule set up to highlight any cell between column Y6 and AU6 if the value of those cells are greater than the value in cell t6.
I pulled the absolute reference to rows out, only leaving the column - so the rules are something like the following -
Cell Rule "Cell Value > $T9", Applies to "=$Y$9:$AU$9"
Cell Rule "Cell Value > $T10", Applies to "=$Y$10:$AU$10"
...and so on...
When I try to remove the absolute reference on any of the "Applies To" criteria, Excle just puts it right back in:
=$Y9:$AU9 changes to =$Y$9:$AU$9
...however, the cell it validates against will allow the absolute reference to change.
The "paste special, format only" process doesn't copy the conditional formatting - the only way I can "copy" this rule is to select a set of cells ($Y$9:$AU$9), click the "Format Painter", then select a new series ($Y$10:$AU$10) and the rule applies (moving
the validation cell down one row).
Now this isn't bad on a small scale, but considering I have to apply this same type of validation rule for all rows between 6 and 424, the prospect of using the "format painter" on EVERY line is ...
Is there a way you can get a conditional formatting rule to copy, something equivalent to the way you can copy formatting and values by selecting a cell, clicking the bottom right corner of your selection and dragging down?
Keys to the Problem applying conditional formatting to additional cells
Another Safe way to Repair the problem: applying conditional formatting to additional cells:Click here to download the registry repair application .
How to Fix applying conditional formatting to additional cells with SmartPCFixer?
1. Download Error Fixer. Install it on your system.
2. After the scan is done, you can see the errors and problems which need to be fixed.
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 SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.
Related: Streets Trips worked in Vista but not in Windows 7 popup says your registry settings for this application were not copied correctly I ve tried to reinstall TOC does not match document for reviewers system restore points will not work The links in Favorites do not work the error Can not allocate memory for DLL keeps popping up and will not go away what do i do The temp directory does not have a command line Is the error box I get when I try to change what program opens a file Transcend Information 160GB StoreJet External Hard Drive WINDOWS 7 COULDNOT OPEN VPN connection is not working in Windows 7 but it worked in Windows XP Two computers open the same file from the server and the text is hidden on one and not the other The procedure entry point DwmHintDxUpdate could not be located in the dynamic link library USER32 dll VBA question Custom Footers in an Active Sheet using values from another sheet tie if function to another cell if function Webcam and microphone not working drivers say it s working properly after I reinstalled them but webcam still not working Unable to read SD card and needs USB 2 0 CRW driver for Samsung notebook when attempting to attach file in email not all files appear when browsing Start up button blinks when trying to start computer does not start,Microsoft Office Starter not loading ISSUE 1 Security Update for Windows 7 KB982665 will not install ISSUE 2 I keep getting random BSODs and I ve ran every check that I can think of mse does not complete its scan blue screen of death Microsoft NET Framework Version 2 0 Redistributable Package x86 not compatible with Win7 Message when shutting off one program still needs to close waiting for explorer exe playing logoff sound on new HP notebook that runs on Windows7 and IE8 my computer does not open as it should then I press button to turn off computer the it come on with messeage telling me to press for start repair why Message that I do not have access privileges when trying to access one PC on the home network my network drive is not working what can i do to fix My function keys on my Dell Inspiron 1545 are not working after installing Windows 7 My Windows 7 Speech recognition many a times does not reognize voice commands and spell it letters Please save me New docm using a dotm template does not work Office 2010 Windows 7 New caption label for Appendices does not increment the number of figure Jzip compressed program files and OS files Nothing runs on startup normal dot from 2003 to 2010 will not accept My Windows Mails will not stop sending old emails Everytime I hit send receive it sends out thousands of old emails from years ago Anyone ever encounter this,|1 GB Network Adaptor for Windows 7|1 TB external hard drive is not recognized by Windows 7|1 XP PC not showing in My Network Places and Networks in Windows 7|1 Laptop shuts down when hibernating 2 Windows Explorer stop responding when inserting USB resuming from sleep hibernate|1 999 number saying there were responding to Windows messages from my computer|1 Cannot access Windows messenger hotmail error 80048820 2 I also do not have access to Internet explorer|1 20 11 Windows Preparing To Configure Windows|1053 printer spooler error in Windows 7|1080p setting is gone in Windows Movie Maker|114 errors Windows Vista Home Premium|13 Windows 7 updates repeatedly failing receiving error message 800B0100 and 8007065E|16 bit MS DOS subsystem and NTVDM exe Errors on Windows 7|1723 There is a problem with this Windows Installer package A DLL required|1 System Restore Error 0x80042318 2 Windows Media Player 11 Will not open 3 Internet Explorer 8 Freezes as soon as opened|2 GIG SD Cards and Windows 7 64 Bit Puzzler|2 week old computer with Windows 7 can t play videos any more In a pop up it recommends to install Adobe Flash Player Installer|2 Windows 8 Blue Screens in just 5 minutes|2 3 Times BSOD Everyday after Upgrading to Windows 8 1|20 Minute boot time in fresh Windows 7 install|2010 Office word on Windows 7 laptop doesn t have all the symbols ie Mathematical operators that are on my Windows 8 desktop|2011 Macbook Pro running Bootcamp Windows 7 Home Premium 64 bit freezes randomly beeping crackle sounds|28 plus Blank pages in Windows 7 Word 2007|2nd hard disk not recognized by Windows 7 after Windows update|3 Apps restriction with Windows 7 starter|3 Windows 7 Laptops getting the same DSN Server Not Responding Error|3 00 GB Usable Have 4GB installed and HP website states this model supports 4GB Windows 7 Ultimate 64 After downloading windows 7 my ASUS F5RL s built in webcam does not work anymore I previously had Windows Vista Home Premium before I downloaded Windows 7 computer shuts off without apparent reason It does this every few minutes Using Windows Vista Home Premium SP 2 am unable to open hlp file on Windows 7 machine A person for whom I just installed Windows 7 32 bit has a similar problem to what is described The message is occuring with the sidebar gadgets BSOD in Windows 8 1 ntoskrnl exe DRIVER POWER STATE FAILURE Cannot email a bing map link in Vista Windows mail Can t see graphics and dispaly windows doesn t cover in Windows 7 data transfer from Windows to iPad Clean install of Windows 7 Professional on a new ssd Cannot uninstall programs in control panel in Windows 8 1 pro Dell AIO A920 Unable to print after upgrade to Windows 7 Can not run back up in Windows 7 or system image in Windows 7 Desktop icons won t open in Windows 7 Still need answer Clicking on Rate This Computer Does nothing Windows Experience Index Distorted cracked up Clips in final saved movie I am currently using Windows 7 Live Movie Maker,Allow network access to my Windows 7 machine from a Windows Vista machine without using Homegroup ati drivers windows 7 dictionary Windows Media Player www ati com I have today installed Microsoft anti virus but now Windows Defender is switched off ati radeon hd 4800 driver Problem with Windows Installer Cleanup Utility ati radeon hd 4800 driver Start menu in Windows 8 ati radeon hd 3200 driver Windows 7 screen saver resets to 1 minute ati radeon hd 4650 treiber Windows Virtual PC KB 958559 ati radeon hd 4800 driver ATKACPI driver and hotkey-related utilities Version V1.0.0037 , 12.8 MBytes,Can t set up a broadband network connection that doesn t require me to log on Windows 7 Home Premium vaio drivers I currently have vista and need to upgarde my office programs word etc I was just going to buy the microsoft office home and student edition If I buy the Windows 7 upgrade does it come with word etc Sony VAIO Driver Download Nimbuzz 2 5 2 Program showing not compatable Problem in Windows 8 VAIO Driver Download Poor graphics after Windows 7 install vaio drivers update Start Windows Media Center automatically when Windows 8 1 starts VAIO Driver Download Windows freezes and shuts down with no warning sony viao drivers Windows Vista Mail Delete Contacts vaio drivers update Intel® Dynamic Platform and Thermal Framework Drive Version V184.108.40.2065 , 6.62 MBytes
Read More: How to Resolve - \"Non-existent\" add-in causing problems?,How to Resolve - service host hogging up cpu after windows 8.1 update 1?,I received error 80070002 when I tried to update windows. [Solved],[Solution] My new HP is running slow as the day wares on. Im also getting pop-up messages from Norton that my CPU is at 99%,combobox event [Anwsered],A problem with this website has caused Internet Explorer to close and reopen this tab,Excel 2007 | Simple Formulas Not Calculating and Zeroing Out,backup does not start 2,WORD 2010 - Spacing between numbered list and a sub level,Virtual PC 2007 VM Additions failure