Change the conditional format color for a specific cell.

asked 2017-12-04 05:34:18 +0100

estes53 gravatar image

updated 2017-12-04 05:41:47 +0100

I have a coin collection spreadsheet that shows, per country, a conditional format single color bar based on how many coins I have compared to how many were minted (%).

Some countries I do not collect because they do not meet my collection criteria (Non-Precious Metal and Circulated).

I still include those countries in the spreadsheet but am only seeking one coin from each of them.

For those particular countries I would like the color bar to be a different color.

No matter what I do to a bar from one of those countries, all the bars want to change to that color.

What am I possibly doing wrong?

edit retag flag offensive close merge delete


Some idea of what your settings are for the formatting would help us guide you.

robleyd gravatar imagerobleyd ( 2017-12-04 09:49:06 +0100 )edit

The system here is telling me that I need points to send a photo, but is not telling me how to get them, so have posted it here-

estes53 gravatar imageestes53 ( 2017-12-04 14:20:44 +0100 )edit

Facebook tells me "This page isn't available The link you followed may be broken, or the page may have been removed." But in any case I suspect I would need a facebook login, which I don't have. You now have points to upload here so you may prefer to do that.

robleyd gravatar imagerobleyd ( 2017-12-05 08:16:00 +0100 )edit