LinkBack URL
About LinkBacks
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?
conditional format query
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?
Erm ... No!
Please attach the workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Perhaps it has previously been formatted with a colour. Have you tried applying a 'No Fill' to the cell.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Here you go
Last edited by max8719; 12-13-2018 at 11:51 AM.
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.
Where are we looking exactly? I just deleted an H and the cell's yellow colour disappeared, too.Originally Posted by max8719
Here you go
Named range "Range".
hmmmm really it disappeared for you???
Give me a cell reference. K34 works fine.
Hi Ali,
S28 for example
For some reason it's working now......I am bamboozled why they weren't clearing previously?
and its happening again now?? this is strange
It is your end, then - nothing to do with the workbook as far as I can see.
Thanks for checking it out, it should work on another computer then.
Cheers.
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
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks