大家好，請問X軸為年度，我想將113及114年變成紅字，有方法出突顯X軸的值方法嗎?

[0970]

如上圖，我希望X軸113年及114年變成紅字，請問有方法可解決嗎？

[v-tianyich-msft · Accepted solution]

Hi @0970 ,

The X-axis can only have one color, I tried many conditional format schemes and they all only return one color, once multiple colors are available, it will not work. You can use ctrl to select 112 and 113, right click and select group data, which also works to highlight to some extent.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.