conditional format.

Greetings, I keep a diabetic log that is usually 6 months or so. One insulin pen last 28 days and I have a column that I note starting a new pen. I usually have don’t use it all by the 28th day. Therefore, I need to replace that pen. Today, I’m taking that pen twice a day. Usually, I run...

https://docs.google.com/spreadsheets/d/1-f4cUjN5BB0jICErbVqpRA5oyumSLjlMS0xRI6U-PgQ/edit?usp=sharing Hi, I know this is not a googlesheets forum but I'm desperate. I used this forum last year for excell with great results .... fingercroseed. I'm trying to copy the data in this sheet from...

Hello, I need to color a column based on a date in a cell. The tricky part is that the condition format condition is only dependent on the month. Let me give an example: Criteria: 4/18/2016 the data table looks like this: 2/1/2016 3/1/2016 4/1/2016 You can see the 4/18/2016 is not an...

Sometimes excel just baffles me :-( I have a cell (a1) with a date in it, lets say 04/11/13 in the cell at the side I have a formula to ensure I'm not going mad ... =year(a1) the result is 2013 I want to use conditional formatting to fill all cells where the year is 2013 in red. I typed in...

Hi there, I currently have a script set up, that highlights a row when a value is true. I would like to set it other values as well. My Current script: =$B2="English Revision DVD (Single User)" What I would like: =$B2="English Revision DVD (Single User)", OR English Revision Student...

I am comparing two columns in two pivot tables on one sheet. On one column the data starts with a zero and in other column there is no zero, I am using condiformula, =SUMPRODUCT(--ISNUMBER(SEARCH($D$5:$D$240,A6))) On both column to find what is common in each of those columns. The problem is...