google spreadsheet - If column includes a certain value, turn top cell red -

-

i want function can check 1 column value , if @ least 1 value found top cell should become red. intent visualize function of top cell in said column: 

if cell in column "a" = "x" cellbgcolor = red else cellbgcolor=white

i don't mind doing in 2 steps, i.e. if value found type "x" in cell , use conditional formatting paint cell.

please try: 

=match("x",a:a,0)

with applies to range: a1.


Comments

Post a Comment

Popular posts from this blog

c++ - How to add Crypto++ library to Qt project -

-
Image
i downloaded crypto++ source , compiled cryptlib project in visual studio 2013, , added generated .lib file qt project, made .pro file this: qt += core gui qt += sql greaterthan(qt_major_version, 4):qt += widgets target = untitled template = app sources += main.cpp\ mainwindow.cpp headers += mainwindow.h \ databasecontrol.h \ test.h forms += mainwindow.ui win32:config(release, debug|release): libs += -l$$pwd/ -lcryptlib else:win32:config(debug, debug|release): libs += -l$$pwd/ -lcryptlibd else:unix: libs += -l$$pwd/ -lcryptlib includepath += $$pwd/ dependpath += $$pwd/ win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/libcryptlib.a else:win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/libcryptlibd.a else:win32:!win32-g++:config(release, debug|release): pre_targetdeps += $$pwd/cryptlib.lib else:win32:!win32-g++:config(debug, debug|release): pre_targetdeps += $$pwd/cryptlibd.lib else:unix: pre_targetdeps += $$pw...
Read more

python - RuntimeError: Optimal parameters not found: Number of calls to function has reached maxfev = 800 -

-
i have image pick randow row in , try fit gaussian curve in row. using scipy.optimize curve_fit method fitting gaussian. picking of randow rows according array vector [10, 20, 40, 60, 100], meaning in first try pick 10 randow rows (hence, 10 gaussian fits) in image, then, more rows selected , on. most of time, code working, however, error (especially, when number of rows large: around 60 or more), says optimal parameters not found . i have found similar posts in stackoverflow still can not able solve problem. seems problem appears quite curve_fit method . laser beam, chance? ;-) anyway, problem rows selected "hard" fit gaussian curve scipy's curve_fit function. first suggestion debug (using e.g. python's logging module) see if error pops on specific rows. my second suggestion change initial guess curve_fit. rows curve-fitting possible, should able extract few parameters. on other rows, mean of gaussian @ approximately same position , aplitud...
Read more

flash - Air stagewebview scroll manipulation -

-
i need desktop adobe air app scroll both vertically , horizontally stagewebview (in order center content) after load completed, hide scroll vars of stagewebview , prevent scroll after initial repositioning without affecting interaction inside external document (internal scroll bars in div). right i've been able of load external url searched rest without luck. or advice and/or documentation? thank in advance guys , have nice week. the following code center scroll , hide scroll bars: var scrollbarwidth:int = 15; var maxhscroll:int = html.htmlloader.contentwidth-html.width+scrollbarwidth; var maxvscroll:int = html.htmlloader.contentheight-html.height+scrollbarwidth; html.horizontalscrollposition = (maxhscroll /2); html.verticalscrollposition = ( maxvscroll /2); html.verticalscrollpolicy = "off"; html.horizontalscrollpolicy = "off"; see ...
Read more