2

After continuing to play around with functions, I was able to find a solution! Here is the solution for those trying to attempt something similar: =IF((AND((MOD(A:A,4) = 0),(NOT(ISBLANK(A:A))))), true, false)


2

This is totally working for byte formatting (bytes - GB): =if(B23>=1024; if(B23>=(1024*1024); if(B23>=(1024*1024*1024); B23/(1024*1024*1024)&" GB"; B23/(1024*1024)&" MB");B23/1024&" kB");B23&"bytes") Can be used for any other magnitude by just altering the numbers and the string labels. Note: you need an & between the number ...


2

Please place the following formula in cell H1: =SEARCH("-",$D1)


2

It looks a little complicated in Google Sheets, but the formatting for a query that you could use in the conditional formatting is here: https://infoinspired.com/google-docs/spreadsheet/datetime-in-query-in-google-sheets/


1

EDIT (following your comment) All duplicate values highlighted in both columns is achieved using: In range D3:D27: =COUNTIF($A$3:$A,D3) In range A3:A27: =COUNTIF($D$3:$D,A3) First approach I believe the formula you need is as simple as: =$A1="Roman"


1

You just need to type =k$11 instead.


1

I have a cell with a check box. I want another cell which contains a date to go green when the tick box is checked. You go to Format, Conditional Formatting and use the Custom formula: =COUNTIF($D3, "=TRUE") EXTRA: On the other hand, if you want the whole range/column to be highlighted use the following formula: =COUNTIF($B$3, "=TRUE") Pay ...


1

This should do the trick: and(today()>start_date,today()<end_date)


1

The formula you need is the following: =NOT(ISBLANK($H3))*(ISBLANK(I3)) Please pay attention to the $ sign in front of H3. Using the $ (dollar) sign we "lock" the column and the formatting is being applied on the whole row. You apply the formula on the range I3:AA.


1

Use the conditional formula =$B2>$D$5.


1

You would need 2 rules to achieve your results. The 1st one -as you already mentioned- is Text contains 0 The 2nd is very similar to your 1st one Text contains 00 Filters must be in the correct order Filters in the wrong order give you wrong results


1

The formula you need for range A1:A is: =and(A1<>"",counta(B1:J1)<>0)


1

You should use the following formula having an IF statement: =(IFERROR(MAX(SPLIT(D3,"-")),0))>F3


1

Use the custom formula =NOT(ISBLANK(C2))


1

You can use conditional formatting with a custom formula like =NOT(ISBLANK(B2)) across the range you want to use, in this case C2:C60. Make sure not to use any $ signs and to reference the first cell in your range (in your screenshot there's an offset), it should be B2. Another reason why your set-up may not work is because the top-most conditional ...


1

Two solutions. A/ Either you do a condition for each case =A1>A2 BLUE =AND(A1>0,A1<A2) YELLOW =A1<0 RED B/ You set the cell in yellow and put only 2 condition format rules. =A1>A2 BLUE =A1<0 RED


1

Try REGEXMATCH : =OR(REGEXMATCH($B2,"yr"),REGEXMATCH($C2,"yr")) Second entry is a JS regular expression. You can build it with a tool like regexr.


1

Actually I found a very simple answer. =COUNTBLANK() and it's working. Thanks anyway


1

=OR(D$2="Sat",D$2="Sun") is the custom formula I use to change column colour if the header (line 2 in the sheet) is Sat or Sun. To use a full word, just type it inside the quotation marks. The dollar sign $ locks the formula to row 2 over the range. So if you put the Dollar Sign $ in front of the column letter, it will check the column instead of the row.


1

A custom formula in the Conditional Formatting interface can do this for you. It looks like your dates in Column C are formatted as dates, and not just text. So I'll demonstrate a formula that will work in that case. (If your Column C is just text, you can adjust the formula to look for the strings "Saturday" or "Sunday".) Select Cell D13. Click on the Fill ...


Only top voted, non community-wiki answers of a minimum length are eligible