Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: [Office 2010]Unable to Fill Conditional format down the entire Column

08 Jun 2012   #1

Windows 7 Ultimate x64 Version 6.1 (Build 7600)
 
 
[Office 2010]Unable to Fill Conditional format down the entire Column

Hi everyone

I have a sheet which has 3 dates - Invoice, Po and Recieved. Invoice date must not be before PO date (can be same) and also Invoice date must not be after Recieved date (can be same). Lets assume Invoice date column is A, PO date column is B and RT date column is C

I have applied the following conditions

=A2<B2 (highlight cell in red) - for invoice being before PO
=A2>C2 (highlight cell in red) - for invoice being after recieved
=A2="" (no highlight) - If I don't give this condition, cell always remains highlighted.

The formatting works fine, but I'm unable to fill this conditional formatting down the entire column (column A) when I attempt to do this, the conditions are always being referenced to the original cell - Also, I'm not using absolute references (using $ sign) - I tried to copy the first cell and then paste special formats down the entrie column, but it didn't work - Tried the format painter as well but to no avail - the one thing I found working was double clicking the format painter and clicking on each cell individually - this results in correct formulas, but this is tedious for me as there are more than 1000 rows in my sheet.

Any help would be greatly appreciated! I'm attaching a sample sheet for reference - please rename it to .xls for viewing, I'm unable to upload xls file.



Attached Files
File Type: txt Conditional Formatiing.txt (30.5 KB, 8 views)
My System SpecsSystem Spec
.

Reply

 [Office 2010]Unable to Fill Conditional format down the entire Column




Thread Tools



Similar help and support threads for2: [Office 2010]Unable to Fill Conditional format down the entire Column
Thread Forum
Solved Unable to install Office 2010 Pro Plus Microsoft Office
excel 2010 conditional formating Microsoft Office
How to make a remote desktop connection fill in my entire monitor? Network & Sharing
An HTML5 Exploit Can Fill Your Entire Hard Drive Quick System Security
Solved Unable to Install MS Office 2010 Microsoft Office
Unable to Install office 2010 Microsoft Office
Unable to install Office 2010 beta Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:27 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33