Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Thank you Jim, very interesting, I didn't know about the TEXT function; I'll give it a try!

Meanwhile, it seems like I have succeeded in using conditional formatting, like this:

https://drive.google.com/open?id=1x0xKtDXeGGmbfvj_U629zQ8D6PNxVIbk

(to see the conditions applied to the data in your screenshot, replace Q52 and R52 with A2:A500 and B2 respectively ... I had to create a custom style for each currency I am testing against)

It took me a long while to figure it out, because I was missing to first clear all existing formatting for the cells in column Q (column with numbers in my table)

The table I am building is a work-in-progress, I haven't had the chance to 100% verify this approach, but at first glance it seems to work.

Thank you Jim, very interesting, I didn't know about the TEXT function; I'll give it a try!

Meanwhile, it seems like I have succeeded in using conditional formatting, like this:

https://drive.google.com/open?id=1x0xKtDXeGGmbfvj_U629zQ8D6PNxVIbk

(to see the conditions applied to the data in your screenshot, replace Q52 and R52 with A2:A500 and B2 respectively ... I had to create a custom style for each currency I am testing against)

It took me a long while to figure it out, because I was missing to first clear all existing formatting for the cells in column Q (column with numbers in my table)

The table I am building is a work-in-progress, I haven't had the chance to 100% verify this approach, but at first glance it seems to work.