About 1,243,405 results (5,230 milliseconds)
IF Then Else statement to update a column
https://groups.google.com/g/mapinfo-l/c/PHYlQHOoRKo May 5, 2015 ... I have a column in a table "Dev_current_5yr_2D" that I want to update based on a couple of conditions. I have been trying write an IF THEN ELSE type statement ...
How can I copy data from one sheet to another using IF statements ...
https://support.google.com/docs/thread/109233301/how-can-i-copy-data-from-one-sheet-to-another-using-if-statements?hl=en May 9, 2021 ... I then want to use something like an IF statement to sort all data by column C. IF data in Column C = (A, B, C, etc.), THEN copy row to sheet (A, B, C, etc.).
Multiple IF Statements within 1 IF Statement for 4 potential output ...
https://support.google.com/docs/thread/15373515/multiple-if-statements-within-1-if-statement-for-4-potential-output-values?hl=en Sep 26, 2019 ... If Col I is not 100% and today is past End Date, then status is 'Stuck'. The Priority Column's If Statement should do the following: If today ...
Need a formula that if cell E2 is Yes, then divide another column by ...
https://support.google.com/docs/thread/5187180/need-a-formula-that-if-cell-e2-is-yes-then-divide-another-column-by-2-and-enter-result-in-e6?hl=en Apr 30, 2019 ... I have a spreadsheet that calculates my budget. I split some expenses with my husband. In each row, I have a cell with the original amount, followed by a cell ...
Conditional formatting: remove cell highlight if cell in next column ...
https://support.google.com/docs/thread/33397994/conditional-formatting-remove-cell-highlight-if-cell-in-next-column-contains-text?hl=en Mar 13, 2020 ... I currently have conditional formatting in column C, whereby, if the deadline has passed, the cell turns red; if the deadline is today, it's yellow; and if the ...
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a ...
Fill Cell Based Conditional on Values in Two Different Columns ...
https://support.google.com/docs/thread/33134263/fill-cell-based-conditional-on-values-in-two-different-columns-concatenated-if-function?hl=en Mar 11, 2020 ... Glad you found an answer to this. If this is a Google Sheet (not the Excel file you have linked), this method might be a little easier since ...
If all checkboxes are checked in a row, I want an automatic ...
https://support.google.com/docs/thread/177314560/if-all-checkboxes-are-checked-in-a-row-i-want-an-automatic-strikethrough-on-the-name-in-the-row?hl=en Aug 30, 2022 ... Uh... do you think there might be some way to make the conditional formatting so that the checkbox in the left column will automatically become ...
Conditional format function to apply to corresponding column ...
https://support.google.com/docs/thread/73215305/conditional-format-function-to-apply-to-corresponding-column?hl=en Sep 25, 2020 ... I successfully did this using the "conditional formatting > custom formula is > =F$2=TODAY() " [note used F as example because writing this ...
Conditional formatting if any cell is blank - Google Docs Editors ...
https://support.google.com/docs/thread/22679297/conditional-formatting-if-any-cell-is-blank?hl=en Dec 12, 2019 ... Basically i want conditionally formatting in a cell if ANY of the other cells in the row are missing or if column E is filled.
How do I make newly added rows automatically inherit pre-existing ...
https://support.google.com/docs/thread/11907000/how-do-i-make-newly-added-rows-automatically-inherit-pre-existing-formulas?hl=en Aug 13, 2019 ... Conditional formatting highlights the calculated value in Column R, if any, otherwise it does nothing. Whenever I add a new row into this sheet, ...
Highlight max/min of columns per month - Google Docs Editors ...
https://support.google.com/docs/thread/156036842/highlight-max-min-of-columns-per-month?hl=en Mar 20, 2022 ... If anyone else has a different approach I am sure they will offer it. You can use what I have offered to add all the other required Conditional ...
How to automatically format cell colors based on Booleans - Google ...
https://support.google.com/docs/thread/5542742/how-to-automatically-format-cell-colors-based-on-booleans?hl=en May 6, 2019 ... ... rows, if End Use Date column is not empty, set row color to red. But I'm not sure how to write this formula. I considered doing a conditional ...
Apply two conditional formatting rules simultaneously in Google ...
https://support.google.com/docs/thread/13813522/apply-two-conditional-formatting-rules-simultaneously-in-google-sheets?hl=en Sep 7, 2019 ... For example, if the course is CHEM 212, I want columns C and D to have a light green fill colour. If the text in column D contains "quiz," then ...
Highlight cells in column B if column A matches a cell in column E ...
https://support.google.com/docs/thread/102320558/highlight-cells-in-column-b-if-column-a-matches-a-cell-in-column-e?hl=en Mar 15, 2021 ... I'm trying to come up with a custom conditional formatting formula that will format the cell in col B if col A matches any cell in col E.
Conditional Format a table using rows and columns - Google Docs ...
https://support.google.com/docs/thread/78502183/conditional-format-a-table-using-rows-and-columns?hl=en Oct 22, 2020 ... ... write a formula for cell $E4,$Z4. I'm wanting the formula to scan the row that it is in, see if there is a cell with text between $G through $X, ...
How to apply conditional formatting to multiple columns, when ...
https://support.google.com/docs/thread/145408803/how-to-apply-conditional-formatting-to-multiple-columns-when-condition-relies-on-a-single-column?hl=en Jan 12, 2022 ... I'm creating a budget spreadsheet, where each row is a different ... So I want the conditional formatting to apply to J5:U18, if the ...
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 ... I am looking to color the cell D5 green if it is greater than or equal to D4. I used Format --> Conditional Formatting and picked the "Greater than or Equal to ...
How to write formula for conditional formatting date from column L + ...
https://support.google.com/docs/thread/242711222/how-to-write-formula-for-conditional-formatting-date-from-column-l-90-days-to-red?hl=en Nov 6, 2023 ... I have a Google sheet with a column of dates (L) of contact, I need cells in a later column(T) to turn red if it's 90 days past that date (L) to cue re- ...
Conditional IF statement not working - Google Docs Editors ...
https://support.google.com/docs/thread/59831408/conditional-if-statement-not-working?hl=en Jul 19, 2020 ... I am trying to apply custom formula conditional formatting to the address column to turn the background red and the text white if the “Do Again” column ...