John_2357

asked on

# OO SCalsc Conditional formatting is not working as anticipated.

I have these cells in row 69:

W X Y Z

-44.21 0 0 -42.34

I want to conditionally format the cell in W69 if Z69 < 0 AND W69 < Z69

This formula works:

(Z69 < 0) AND (W69 < Z69)

But when I copy the cell 'W69' (CTRL+C) and then paste special to cell W70 (ALT+SHIFT+V and only select 'Formats" the cell is not highlighted even through the condition is true. I can double check that the paste was valid (Format-Cond. Formatting) and the formula is correct.

What is going on? Why is the formula not working?

W X Y Z

-44.21 0 0 -42.34

I want to conditionally format the cell in W69 if Z69 < 0 AND W69 < Z69

This formula works:

(Z69 < 0) AND (W69 < Z69)

But when I copy the cell 'W69' (CTRL+C) and then paste special to cell W70 (ALT+SHIFT+V and only select 'Formats" the cell is not highlighted even through the condition is true. I can double check that the paste was valid (Format-Cond. Formatting) and the formula is correct.

What is going on? Why is the formula not working?

ASKER

W70 is -23.1 and Z70 is -18.34

I inserted another new worksheet after the sheet causing the problem, it seems that the new sheet inherited the formatting from the previous sheet. I typed in some random numbers so that the formula would be true and agaIN ROW 69 WORKS AND ROW 70 does not. The spreadsheet is too big to post, I am sorry.

Is there a setting that can be un-checked so that new sheets do not inherit the previous sheet formats/formulas etc? Is there or can there be hidden formulas/formats that are somehow over-riding the ones I set? I am using OpenOffice.org 3.1.1 OOO310m19 (Build:9420)

Thank you for your help.

I inserted another new worksheet after the sheet causing the problem, it seems that the new sheet inherited the formatting from the previous sheet. I typed in some random numbers so that the formula would be true and agaIN ROW 69 WORKS AND ROW 70 does not. The spreadsheet is too big to post, I am sorry.

Is there a setting that can be un-checked so that new sheets do not inherit the previous sheet formats/formulas etc? Is there or can there be hidden formulas/formats that are somehow over-riding the ones I set? I am using OpenOffice.org 3.1.1 OOO310m19 (Build:9420)

Thank you for your help.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Creating a new workbook solved the problem. I would like to know why the old workbook generated the headaches. However I do not have the time to worry about it. Thank you for your help.

I glad you got it fixed. The only way to determine the original problem is for us to look at the sheet. By the way, before closing questions, I suggest you look at the following article to get a feel for use of EE's grading system.

https://www.experts-exchange.com/Community_Support/General/A_2786-How-do-I-close-a-question-at-Experts-Exchange.html?sfQueryTermInfo=1+30+answer+rate

-Bear

https://www.experts-exchange.com/Community_Support/General/A_2786-How-do-I-close-a-question-at-Experts-Exchange.html?sfQueryTermInfo=1+30+answer+rate

-Bear

-Bear