#1
|
|||
|
|||
The same Conditional Formatting works in one worksheet but not another
If I create a conditional formatting rule:
=$D72>$B72 Applies to: $A$72:$G$75 to a blank worksheet, with all cells formatted as General and containing only numbers, it works fine, highlighting cells in the "Applies to" range where the condition is met. However if I apply the same rule to a populated worksheet with a variety of formats (but with columns B and D formatted as General) it doesn't work. What could be different about this worksheet that would prevent the Conditional Formatting from working? If I insert a new column and in cell F72 enter '=D72>B72', then copy the formula to other cells in the column, I get the expected TRUE and FALSE answers. If I revise the conditional formatting condition to: =$F72=TRUE then again the conditional formatting works. |
#2
|
||||
|
||||
Hi
seeing the real sheet ( not a picture) would be a great help. Be aware that formatting dos not change underlying values, it is just the way XL shows things to the outside world. This being said be also aware that in a comparison, text is ALWAYS larger than any number. If you can provide the sheet, I will explain why. and text is always left aligned in a cell when no manual alignment has been applied even if it looks like a number)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks Pecoflyer - I appreciate your comments.
I've been trying things in the meantime, revising the formula, rebooting a couple of times, etc. I'm both happy and sad that (1) the conditional formatting now works and (2) I have no idea why. I'm now using a slightly different formula, but I've verified that the original one now works (but don't know why). |
#4
|
||||
|
||||
Please mark thread as "solved". Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
conditional formatting |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Autocorrect formatting works randomly | Gamma Sigma | Word | 3 | 03-19-2021 11:51 AM |
Conditional Formatting | RocketRon | Excel Programming | 2 | 11-25-2019 08:36 AM |
Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Protecting the formatting and formulas in a worksheet | furface00 | Excel | 5 | 02-27-2011 02:22 PM |