1,028 votes262 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks for supporting this feature. We won’t be able to offer this in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex. Old versions of Excel will not support the new behavior, so there would need to be some hybrid approach that will be suitable for old and new versions. Also, named ranges can be dynamic, meaning that the range might change and conditional formatting rules would have to be adjusted when the workbook is calculated. There are lots of cases to consider and deal with properly.
We’ll continue tracking votes for this suggestion.
An error occurred while saving the commentToni commented
Please, I would love to format according to conditions, but as it is now it is kind of useless since I can't trust what is does! I said please, so you have to at least give it a look.... Been 5 years already since this was posted and you guys have done nothing!Toni supported this idea ·