Conditional formatting problems

[Yusufcanyilan]

Hi guys,

I'm working on a file that should be able to show the color green in a cell in "sheet 1", depending on if e.g cell A1 in "sheet 2" isn't equal to zero.

I've formatted the cells which is not an issue. The problem though, was that when I was selecting "sheet 2", and typing anything in that particular cell, every cell from "sheet 1" that is not empty, shows up in front of "sheet 2"..

What's even more weird is that when I delete all the formattings, it continues doing the exact same thing.

I would be very thankful if anyone could help me solve this.

Sincerely,
Yusuf Can Yilan

 

[mole999]

is the cell actually formatted as green to start with

 

[Yusufcanyilan]

Hi Mole999,

No it's not.

 

[mole999]

so, with the cell selected, look at conditional formatting rules for the selection

 

[Yusufcanyilan]

so, with the cell selected, look at conditional formatting rules for the selection

Hi Mole999,

Thank you for your answer, but the problem was not a simple conditional formatting problem. It was more like an Excel error when working with vba.

I couldn't figure out why it did as it did, but I moved the destination cells to another sheet, and everything worked just fine afterwards.

Thank you anyway. Much appreciated!

 

[mole999]

if you post the vba, probably with INTERSECT code lines