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)
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 ...
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/
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)
I believe the formula you need is as simple as: =$A1="Roman"
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:
On the other hand, if you want the whole range/column to be highlighted use the following formula:
The formula you need is the following:
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.
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
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 ...
=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.
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 ...