Teams - Excel - Conditional formatting - only 3 colours?

Occasional Visitor

I'm trying to conditional format some data in Excel on Teams using different colours, like you can do in 'normal' Excel.


Literally just 

0 - red

1 - orange

2 - green

3 - blue

4 - yellow etc


When I try to apply conditional formatting to these values in Teams Excel it only gives me the below options! Am I missing something. I can do this easily in Desktop Excel or in Sheets in Google Drive. Why can't I select more colours in Teams Excel?


Screenshot 2022-02-08 at 9.36.49 AM.png

0 Replies