About 1,780,241 results (2,050 milliseconds)
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:// ...
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 enter a numerical value (equal to D4) in the value box, it ... Example: If you have the custom formula: =A1<10 and have it applied ...
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 ... I can get it to work on a single cell no problem with the drop down options and the custom formula (e.g. =G3<G2). As soon as I try to apply ...
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.
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 ...
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 ...
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 ... Get link. Report abuse. Highlight Cells that are Greater than 7 ... Format Cells If: Custom Formula; Custom Formula Is: =$BN1=today()-7 ...
I applied conditional formatting to turn cells red if it is greater than ...
https://support.google.com/docs/thread/139259097/i-applied-conditional-formatting-to-turn-cells-red-if-it-is-greater-than-another-cell-in-the-previou?hl=en Dec 7, 2021 ... I also tried to use Format cells if "greater than" but I can't click the previous column to put it in the value or formula line.
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 ... ... conditional formatting rule's custom formula for every cell to make it change? ... if greater than or equal to it should be green. The way ...
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 ...
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 ... ... greater than D11 - and many that are highlighted are less) - How do I get this to happen? Ideally it'd be great if I could get a gradient ...
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 ...
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 ... ... Conditional Formatting, when you enter a formula (preceeded by =) ... I know it will get an extra level of unwieldy if I need to add some ...
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.
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 ... Then, under the Format rules, Format cells if ..., select Custom formula is.... Then in the box/field below, enter this formula: =V2<(TODAY()- ...
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 ...
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 the ...
IF CELL VALUE is less than and greater than, replace with Value "X ...
https://support.google.com/docs/thread/4172165/if-cell-value-is-less-than-and-greater-than-replace-with-value-x?hl=en Apr 14, 2019 ... I need to create a formula that provides a VALUE if the CELL NUMBER is between a greater than and less than range.