Ask Your Question

Color coding is not working (probably because number formating), how can I make it work?

asked 2019-10-01 21:14:52 +0100

updated 2019-10-01 21:15:11 +0100

Hey there, Im trying to color code a sheet but Im unable to do so properly.

First, some numbers on a column are on a different format than the others, and even tho I set the whole column to be "general" number format they still remain different as seen in the picture below.

I tried adding a dot to match the format of the rest of the numbers on the column but the program automatically erases the dot and leaves the number as it was.

image description

This also generates a problem when trying to color code the whole document, as only some cells are colored as shown below:

image description

Im a noob when it comes to sheets and im not really sure what I should do to prevent this from happening and be able to color code properly the whole document.

Thanks in advance

edit retag flag offensive close merge delete


Please be more specific. Can you verify that on your example there are seven columns that have colored cells in them? I want to be able to talk about specific columns while trying to answer your question.

larrybradley gravatar imagelarrybradley ( 2019-10-01 22:25:56 +0100 )edit

Correction: There are only five columns in your example that have colored cells. Correct?

larrybradley gravatar imagelarrybradley ( 2019-10-01 22:27:39 +0100 )edit

yes indeed, only first, third, fourth, sixth and seventh column are colored.

Tried to follow the steps on the answer provided by erAck below but it didnt work.

Thanks in advance for any info you can provide and lmk if there's anything else unclear.

shankar18 gravatar imageshankar18 ( 2019-10-02 18:18:38 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-01 21:19:27 +0100

erAck gravatar image

Looks like your left aligned "numbers" are text content instead of numeric content. Try this FAQ.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-01 21:14:52 +0100

Seen: 64 times

Last updated: Oct 01 '19