javascript - How to count cells with bold text and set a value and background color for another cells based on that in Google Sheets? -


i have poule table here: https://docs.google.com/spreadsheets/d/1wnefubw1rgh_koza_pj7-l9q6cyvrifqpk31spqn0nu/edit?usp=sharing

i've used built-in conditional formatting high lighting cells plays against , making score bold if it's higher opponent's. working until column f loser winners game play against winner losers game. there think easiest way find out need play (and high light corresponding cell) checking font weight in other columns.

so, every row in column f (actually f6:f12) need check following: if font weight not bold in d6:d12 or font weight bold in e6:e12 set background color of cell x (e.g. yellow).

for column g (place) need more complex formula. there want set correct place based on how many cells font weight bold there are. formula g6 should this:

if c6 , d6 font weight bold return "i".  if c6:f6 bold count = 2 return "ii"  if c6:f6 bold count = 1 return "3."  if c6:f6 bold count = 0 return "4." 

the formula g8, g10 , g12 should similar, need check different rows.

i know need use script editor , i've found few scripts adding values of cells font weight bold, don't know how modify these correctly need.

any welcome.


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -