Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format fails when copied
I am formatting cells based on the following equations
=AND(G8,(MOD(ROW(),2)=1)) =AND(G8,(MOD(ROW(),2)=0)) =AND(NOT(G8),(MOD(ROW(),2)=1)) =AND(NOT(G8),(MOD(ROW(),2)=0)) G8 is true or false. If I hand enter these rules for each cell it works fine, but if I try to copy the format rules they fail to work correctly. I've opened the copied and failing cells and viewed each rule. Then look correct. They appear identical to the original. I've moved each equation from the copied cell to a stand alone cell on the side and displayed the value of the result, true or false. The values when calculated outside of the conditional format environment are correct. "Applies to" definitions are also correct. Any ideas? excel 2010 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format fails when copied
Hi,
Am Wed, 8 Jan 2014 07:21:28 -0800 (PST) schrieb : =AND(G8,(MOD(ROW(),2)=1)) =AND(G8,(MOD(ROW(),2)=0)) =AND(NOT(G8),(MOD(ROW(),2)=1)) =AND(NOT(G8),(MOD(ROW(),2)=0)) G8 is true or false. if the reference always is G8 you have to set it absolute: =AND($G$8,(MOD(ROW(),2)=1)) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format on copied worksheet stop working | Excel Programming | |||
Copying Conditional Formatting Fails | Excel Programming | |||
macro in copied workbook fails | Excel Programming | |||
Conditional Format Macro fails to set interior color - HELP!!! | Excel Programming | |||
Why my cell format is not copied when I copied workbook? | Excel Programming |