Another Neuron killed by Microsoft Series I – Excel Conditional Formatting

look at d3js

Besides work as an open-resource API, It is quite inspiring to how human should interact with Data.

With keen interest in cognitive science, I understand the importance of visualizing data in helping human process the way-too-much information.

For that, today I just wanted to color a cell by value in other cells. that is.

After some struggles I managed to reference the cell next to it (that is) with some over complex formulas

Note: I know there are some tricks for relative reference but I am not the one to master it. I dont vba or write non-readable excel funcitons everyday. I am able to do it when I need, but it just always takes me too much time on simple stuff like this.

I put the formula into the cell and it evaluates as TRUE

In conditional Formatting I put the same formula, it does not work.

The formula is sth like AND(xxxxx()(xjkl())=a,yyyyyy(fads())=b)

Only after some neurons get killed, I removed the AND() function and it works. WTF

I have no interest to check if it is unsupported, for me this is a bug.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s