Building My Kanban Board From the Ground Up . I built my Excel Kanban board using two sheets: one for the task list (the ...

Individually apply conditional formulas for each cell, and each cell has 2 conditional color scale rules. To begin, select cell A1. Create 2 color scale rules that only apply to cell A1.

To color-code specific text, select the cells that contain (or will contain) the text that you want color-coded. In the example above, I have selected cells B2:B27.