conditional format query

[max8719]

Hi,

In a range I have a conditional format to colour cell if = "H" but when I delete the cell contents the colour still remains, I don't know why this has started to happen i'm sure before the cell returned to a no fill status.

Any ideas?

[AliGW]

Erm ... No!

Please attach the workbook.

[Richard Buttrey]

Perhaps it has previously been formatted with a colour. Have you tried applying a 'No Fill' to the cell.

[max8719]

Here you go

[dosydos]

1. Are your formulas set to Calculate Automatically?

File>Options>Formulas


2. The only other idea i can think of is maybe adding VBA to update your screen

Please Login or Register  to view this content.

[AliGW]

Here you go

Where are we looking exactly? I just deleted an H and the cell's yellow colour disappeared, too.

[max8719]

Named range "Range".

hmmmm really it disappeared for you???

[AliGW]

Give me a cell reference. K34 works fine.

[max8719]

Hi Ali,

S28 for example

[max8719]

For some reason it's working now......I am bamboozled why they weren't clearing previously?

[max8719]

and its happening again now?? this is strange

[AliGW]

It is your end, then - nothing to do with the workbook as far as I can see.

[max8719]

Thanks for checking it out, it should work on another computer then.

Cheers.

[jeffreybrown]

Administrative Note:

• We would love to continue to help you with your query, but first, before we can proceed
• Please see Forum Rule #3 about Cross Posting and adjust accordingly.
• Also, please read A message to forum cross posters