I'm trying to conditionally format a cell with a graduated colour (traffic light: green/ amber/ red), when a range of other cells are completed with text within google sheets.

In other words, 4 cells (B3:B6) will be completed with information so when no cells or 1 cell contains text, then my target cell (B2) will show green. When 2 or 3 cells are completed then B2 will show amber and when all 4 cells are completed then B2 will show red.

I hope this makes sense & can help.

thank you, Toby