Forum Discussion
Conditional formatting based on calculation type
Solved. Started Excel in safe model and narrowed issue to an add-on. Turned out there's an AutoColor feature in Refinitiv Eikon's Excel add-on. I wish these kinds of features weren't on by default. Thanks all.
Timo_Te wrote what's in italics:
Whenever I write an expression...
I'm curious: do you really mean EVERY TIME, EVERY SPREADSHEET? Or is it just in one? Or is it one that is based on a template?
Did you create the spreadsheet(s) in question?
In any event, it sounds like some strange but possible conditional formatting must have been set by somebody.
My first suggestion would be highlight the cells in question, then click on the "Conditional Formatting" icon on the Home toolbar, seen on the far right in this image
Then click on Clear Rules and make your selection as desired.
1) open a New blank workbook (really blank, not using any company template)
2) i took two random excel sheets people had emailed me. One sheet created by a colleague and another by another company
Amazingly, the result is the same. In both cases, if I reproduce the above calculation somewhere in the workbook, I get the coloring in that section.
Additionally, I pressed F2 and Enter on an existing formula on the sheet (ie., made by the sender), and it recalculated it .. and colored it light blue (the cell contained an =iferror() statement).
So it's something that's turned on as default in my computer's Excel, not something that comes with a particular workbook.
I tested the advice you and the other person had given and it had no effect.
