Add color for each cell of column in Microsoft list

Question

hello all,

I have added one screen shot from excel and one from Microsoft lists, I want to add different color for the different cell in one column (here in January i want to add different color for different value like 575000 is in red and 79000 is in blue). Is it possible in Microsoft lists or is this the another limitation of Microsoft lists?

Answer 1

Hi @Ghadage Aniket ,

You could add rules for column value by following steps.
1.Select Column settings->Format this column

2.Choose column->Conditional formatting->Manage rules->Add rule

3.Choose a column, comparison, value.

4.Show list item as->more styles->Change style->Save

5.Shown below.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.