About 1,373,082 results (4,844 milliseconds)
If cell (C3) is greater than cell (B3) colour text green, if C3 is less ...
https://support.google.com/docs/thread/121896053/if-cell-c3-is-greater-than-cell-b3-colour-text-green-if-c3-is-less-than-b3-colour-text-red?hl=en Aug 18, 2021 ... I am trying to create a personal expense tracker and I'd like to use conditional formatting to colour the text based on wether the number is greater or less ...
Conditional Formatting when the value in a cell is greater than the ...
https://support.google.com/docs/thread/5900027/conditional-formatting-when-the-value-in-a-cell-is-greater-than-the-value-in-another-cell?hl=en May 10, 2019 ... If I replace the number with D4, then it is unable to recognize that as the reference to the cell. I tried using the custom formula option but ...
if greater than/equal to 10 return 10, if less than 10 return calculated ...
https://support.google.com/docs/thread/19876526/if-greater-than-equal-to-10-return-10-if-less-than-10-return-calculated-value?hl=en Nov 14, 2019 ... Second version of the formula returns a parse error. Here's the sharable file with the two formulas & what my desired result would be: https:// ...
Using MAXIFS with a criteria that is greater than or equal to a cell ...
https://support.google.com/docs/thread/79983233/using-maxifs-with-a-criteria-that-is-greater-than-or-equal-to-a-cell-reference?hl=en Oct 30, 2020 ... ... Excel I could surround the cell reference ... The formula works fine without the 'greater than' but in that case only returns a result if ...
Conditional formatting entire column to highlight greater than or ...
https://support.google.com/docs/thread/279521652/conditional-formatting-entire-column-to-highlight-greater-than-or-equal-to-another-cell?hl=en Jun 11, 2024 ... My example (no formulas added just coloring): I gave up on this solution and it may be too complicated and that's fine if it is, but my next ...
Conditional Formatting Based on Greater Than a Time Value ...
https://support.google.com/docs/thread/107307114/conditional-formatting-based-on-greater-than-a-time-value?hl=en Apr 23, 2021 ... The white part is the Gantt portion and I'm trying to use Conditional formatting to create a 'thermometer' like color scale. The formula I'm ...
Conditional Formatting if cell is greater/less than cell above - Google ...
https://support.google.com/docs/thread/40734495/conditional-formatting-if-cell-is-greater-less-than-cell-above?hl=en Apr 17, 2020 ... ... formula (e.g. =G3<G2). As soon as I try ... May work for a few cells then stop, or it will make highlight the cell it should be comparing.
How to get if formula to check for if the cell is greater than a number ...
https://support.google.com/docs/thread/2234862/how-to-get-if-formula-to-check-for-if-the-cell-is-greater-than-a-number-but-also-not-null?hl=en Mar 10, 2019 ... I am trying to make the formula check if a student's grade is >79.5 AND the cell is not blank then return yes, if less than 79.5 no.
How can I limit the result of a formula to a maximum value? - Google ...
https://support.google.com/docs/thread/219019092/how-can-i-limit-the-result-of-a-formula-to-a-maximum-value?hl=en Jun 2, 2023 ... ...but I'd like to do something where, if the result is greater than 50, say, I want to limit the cell's output to never show a value higher ...
Conditional formatting = trying to highlight if "Greater Than" - Google ...
https://support.google.com/docs/thread/33289598/conditional-formatting-trying-to-highlight-if-greater-than?hl=en Mar 12, 2020 ... Hello, in my spreadsheet I have a formula in cell E3 that calculates a percentage (e.g. answer is "4.00%"). I change this formula ...
How do I create a IF statement condition using the current time ...
https://support.google.com/docs/thread/174582592/how-do-i-create-a-if-statement-condition-using-the-current-time?hl=en Aug 10, 2022 ... I am creating a social media posting schedule. Under the calendar tab the date in H4 is set to update daily and the formula in F6 is set to match the ...
Using Conditional Formatting to highlight any cell in a table ...
https://support.google.com/docs/thread/116289219/using-conditional-formatting-to-highlight-any-cell-in-a-table-dependant-on-another-particular-cell?hl=en Jul 8, 2021 ... ... formula '=I3>=D11' - both returning the same seemingly random result ... do I get this to happen? Ideally it'd be great if I could get ...
Google Sheets - Conditional Formatting Rules - Want "Custom ...
https://support.google.com/docs/thread/299380936/google-sheets-conditional-formatting-rules-want-custom-formula-to-change-to-pasted-cell?hl=en Sep 29, 2024 ... If that works, I want to do the same with Column E, with the custom formula again changing down each row but instead of looking at Column B it ...
TODAY as a Condition in SUMIFS Function - Google Docs Editors ...
https://support.google.com/docs/thread/12802226/today-as-a-condition-in-sumifs-function?hl=en Aug 25, 2019 ... I'm writing a SUMIFS formula that I want to return the value of a cell if that value is both > 0 and the date is 8/31/2019 or later.
Highlight Cells that are Greater than 7 days - Google Docs Editors ...
https://support.google.com/docs/thread/78170926/highlight-cells-that-are-greater-than-7-days?hl=en Oct 20, 2020 ... I've updated the formatting rules in my sheet copy. Apply To Range: A2:AY132. Format Cells If: Custom formula is. Custom Formula Is: =AND($A2 ...
Conditional formatting to show current time - Google Docs Editors ...
https://support.google.com/docs/thread/125682813/conditional-formatting-to-show-current-time?hl=en Sep 13, 2021 ... Because the formula is using the NOW function, this may not get updated automatically if you don't do anything on the sheet. So if you open ...
Greater Than Filter Only Returning Text - Google Docs Editors ...
https://support.google.com/docs/thread/3868367/greater-than-filter-only-returning-text?hl=en Apr 9, 2019 ... The "custom formula is" option I mentioned will do the same thing but remove blank rows. :) I made a tab with that option too. For changing text ...
Conditional Formatting based on rounded time duration - Google ...
https://support.google.com/docs/thread/239791349/conditional-formatting-based-on-rounded-time-duration?hl=en Oct 18, 2023 ... If it's 6, do you want everything equal to or greater than 6 green? ... Would you suggest or recommend a different formula to calculate the ...
Google Sheets Conditional Formatting Help--dates greater than 275 ...
https://support.google.com/docs/thread/120584337/google-sheets-conditional-formatting-help-dates-greater-than-275-days-ago?hl=en Aug 9, 2021 ... Sheets will update that range to be to the last row in your sheet. Then, under the Format rules, Format cells if ..., select Custom formula is..
Greater than or equal to "but" less than or equal to in google sheets ...
https://support.google.com/docs/thread/149366436/greater-than-or-equal-to-but-less-than-or-equal-to-in-google-sheets?hl=en Feb 4, 2022 ... After A172, each field should count no more than 500, then let the next field take over to count the next 500. my thinking was if I could tell ...