Conditional Formatting Google Sheets cells when in-cell formula is false

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP

Conditional Formatting Google Sheets cells when in-cell formula is false



I am wondering if there is a way to do conditional formatting in the "else" portion of an if statement. For example, right now I have:


=if(MONTH(today())=2, (M2 * Y2), (*turn cell green*))



I can't seem to find a way to do this with conditional formatting (I can only seem to find a way to turn the cell green if a certain event occurs). If I just try to turn the cell green if the month of today is not 2, it will turn green, however the cell text is "FALSE." I would like to turn the cell green but also keep the cell text.




1 Answer
1



So you want to color the cell when the current month is February (2)?



Highlight the cell and add the following as custom formula:


=if(month(today())<>2,true)



Note that the formula of a cell is independent of the conditional formatting. So your turn cell green goes into conditional formatting. The M2*Y2 part goes into the cell :)





Thank you!! I figured out how to get to here : '=$A2<>text(MONTH(today())&"-1","MMMM")'. In A2, I have "February". However, google sheets doesn't think that these are equal, because the cell is changing color. Is there a way to compare two strings that I am missing?
– Ethan Goldberg
Feb 12 at 16:43





In a dummy sheet I tried your function and it is working. If the cell has the value "February" it is not turned green. Otherwise it is always green. Maybe you have an issue with the cell. If your just want to reference one cell use $A$2 to peg both the column and the row. Otherwise the 2 is a relative reference and changes depending on where you apply the conditional formatting. Check this example.
– larsl
Feb 12 at 16:51






Hi Ethan, can you please accept my answer and upvote it, if I helped to solve your problem.
– larsl
Feb 15 at 16:06





Of course!! Thank you again for your patience 🙂
– Ethan Goldberg
Feb 15 at 17:10






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Comments

Post a Comment

Popular posts from this blog

Executable numpy error

Image
Clash Royale CLAN TAG #URR8PPP Executable numpy error I'm trying to create an executable file for my code. I've already tried with cx_Freeze and with pyinstaller. Both gives me the same error, which is: "Missing required dependencies 0.format(missing_dependencies))" PS C:UsersGustavoDesktopbuildexe.win32-3.6> python AgendaOficial.py C:UsersGustavoAppDataLocalProgramsPythonPython36-32python.exe: can't open file 'AgendaOficial.py': [Errno 2] No such file or directory PS C:UsersGustavoDesktopbuildexe.win32-3.6> .AgendaOficial.exe Traceback (most recent call last): File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_Freezeinitscripts__startup__.py", line 14, in run module.run() File "C:UsersGustavoAppDataLocalProgramsPythonPython36-32libsite-packagescx_FreezeinitscriptsConsole.py", line 26, in run exec(code, m. dict ) File "AgendaOficial.py", line 8, in File "C:UsersGustavoAppDataLocal
Read more

PySpark count values by condition

Image
Clash Royale CLAN TAG #URR8PPP PySpark count values by condition I have a DataFrame, a snippet here: [['u1', 1], ['u2', 0]] basically one string ('f') and either a 1 or a 0 for second element ('is_fav'). What I need to do is grouping on the first field and counting the occurrences of 1s and 0s. I was hoping to do something like num_fav = count((col("is_fav") == 1)).alias("num_fav") num_nonfav = count((col("is_fav") == 0)).alias("num_nonfav") df.groupBy("f").agg(num_fav, num_nonfav) It does not work properly, I get in both cases the same result which amounts to the count for the items in the group, so the filter (whether it is a 1 or a 0) seems to be ignored. Does this depend on how count works? count 1 Answer 1 There is no filter here. Both col("is_fav") == 1 and col("is_fav") == 0) are just boolean expressions and count doesn't really care about their value as long a
Read more

Mass disable jenkins jobs

Image
Clash Royale CLAN TAG #URR8PPP Mass disable jenkins jobs Is it possible to disable a large number of Jenkins jobs in one go? I have a large number of jenkins job I need to disable. Visiting each job in turn and disbling is tedious. 2 Answers 2 https://wiki.jenkins-ci.org/display/JENKINS/Configuration+Slicing+Plugin That works beautifully install it go to http://your_jenkins.com:8080/slicing/jobdisabledbool/? By using configuration slicing plugin: By using this plugin easy to find out anything has enabled or disable jobs and timer separated jobs Manage Jenkins >Config slicing > select options By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Read more