Skip to main content
Web Applications

Return to Question

Bumped by Community user
edited tags; edited tags
Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297
deleted 19 characters in body
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

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

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

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.

Source Link
Toby Noyce
Toby Noyce
  • 1

Conditional format a cell with a graduated colour when a range of other cells are completed with text

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