On MS Excel how do you set a conditional for mat to change the row color if it has aged over 10 and 20 days?

Question

Trying to change the color of rows once the line item has hit 10, 20, and 30 days. What is the correct procedure to get that set up so it changes the entire row.

Answer 1

The Conditional Format works only on the cell itself
means, you can not set format for cell A1, if Cell A2 is zero
You will need a macro to do it

mail me here in Y! Answers if you are interested

Enjoy my profile, I am the VBAXLMan

Answer 2

Try using a TIMEREF formula. Or you can plug in a particular reference date at some point on the spreadsheet, then add a column for a formula where you ask for the difference between that cell (with the current date) and the line item. Then do a conditional format for it.

You can also, in a seperate column, type a formula that says "=if(A2>10,"Past Ten Days").

Answer 3

there is not any convinced age yet round 10 weeks is the final. some cats take even longer for his or her eyes to modify. I absolutely have conventional cats take see you later as 4 months earlier their eyes finally substitute.