yogi_Conditionally Format Columnas A2:E If Date In Column A Is Over 13 Months Old

Google Spreadsheet   Post  #2592

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-31-2019

question by: Tico

https://support.google.com/docs/thread/3351311?hl=en
Conditinally format entire row, based off of an "expiration date"
Is there a way to use conditional formatting to recolor an entire row if a cell filled in with a date in the corresponding row is more than a year old

For example,

Cell A1 is marked with a date. The rest of the row (A2:A10) are filled in with several other pieces of information assosiated with that date. I need to set it so that if the date in A1 is more than 13 months old ("expires") that the entire row will shade in. 

I know I can do this setting up a cell to be a "variable" but I would like to do this WITHOUT making another cell. This document will be going live on several business servers and I would like to keep it clean (and the less things people can mess up the better haha)

I am not sure if I am making any sense here... So I also made a test document to try and re explain what I am trying to get done here.

https://docs.google.com/spreadsheets/d/17yV6Nn-7f5CgzrFkU3LWqBv9lvfk8oz4R9v8MH9ugwA/edit?usp=sharing

thank you all for your help!!!

yogi_transpose text data from 8 columns to vertical grouping in google sheet

Google Spreadsheet   Post  #2591

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-24-2019

question by: Brian Pugh

https://support.google.com/docs/thread/2937308?hl=en
Possible to transpose text data from 8 columns to vertical grouping in google sheet? 

I'm trying to help one of our teachers collect grad bios from our 8th grade students and send the data to the yearbook printer. The printer needs each student's submission to be grouped and listed in vertical order (see "vertical order" tab). Is there a formula that will transpose each student's 8 horizontally listed values into groups vertically? Thank you very much. example sheet

Details

Sheets, Microsoft Windows, Education

yogi_Conditionally Format Cells Where Entry After Fourth Dash In Rows 2 and 3 Do Not Match

Google Spreadsheet   Post  #2590

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-15-2019

question by: John Borges

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/eJraFBCs9N0;context-place=forum/docs
Finding Occurrences Where Two Threads in a Multi-lined Cell Do Not Match