Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATING
Please i'm trying to conditional formating the cell and waht to figure out
which way is the best way n right formular to use. thanks for your ideas greater than 90DAYS before this date 02/24/12 = GREEN less than 90DAYS before this date 02/24/12 (that is 89days count down to 02/24/12) = YELLOW pass the due date "02/24/12". That is 02/25/12 should turn to RED. I tried to use CONDITIONAL FORMATING BUT i couldn't get the right formular if you have any idea. please let me know. "Note" I want to apply this to row and there are different date on each cell. Please advice on what to do. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATING
For the green condition, Formula Is =DATE(2012,2,24)-A1=90
For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<90) For the yellow condition, Formula Is: =A1DATE(2012,2,24) where A1 is the cell you are formatting (or the first cell in a range you have selected for formatting) Your conditional actually missed out "equal to 90DAYS before this date 02/24/12 I included that in the green. Use these to include in the yellow For the green condition, Formula Is =DATE(2012,2,24)-A190 For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<=90) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kanmi" wrote in message ... Please i'm trying to conditional formating the cell and waht to figure out which way is the best way n right formular to use. thanks for your ideas greater than 90DAYS before this date 02/24/12 = GREEN less than 90DAYS before this date 02/24/12 (that is 89days count down to 02/24/12) = YELLOW pass the due date "02/24/12". That is 02/25/12 should turn to RED. I tried to use CONDITIONAL FORMATING BUT i couldn't get the right formular if you have any idea. please let me know. "Note" I want to apply this to row and there are different date on each cell. Please advice on what to do. Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATING
Thanks alot for your imput and ideas.
The issue is that we cannot specific the date because it change automatically. I mean you can't determine what date it will be. by this formular stating 2012,2,24. it won't work. We have to make reference to whatever date"cell contents" it is according to < , 90days and more than the contents of the cell but we never can determine the content of the cell. Please advice and Thanks once again. "Bernard Liengme" wrote: For the green condition, Formula Is =DATE(2012,2,24)-A1=90 For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<90) For the yellow condition, Formula Is: =A1DATE(2012,2,24) where A1 is the cell you are formatting (or the first cell in a range you have selected for formatting) Your conditional actually missed out "equal to 90DAYS before this date 02/24/12 I included that in the green. Use these to include in the yellow For the green condition, Formula Is =DATE(2012,2,24)-A190 For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<=90) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kanmi" wrote in message ... Please i'm trying to conditional formating the cell and waht to figure out which way is the best way n right formular to use. thanks for your ideas greater than 90DAYS before this date 02/24/12 = GREEN less than 90DAYS before this date 02/24/12 (that is 89days count down to 02/24/12) = YELLOW pass the due date "02/24/12". That is 02/25/12 should turn to RED. I tried to use CONDITIONAL FORMATING BUT i couldn't get the right formular if you have any idea. please let me know. "Note" I want to apply this to row and there are different date on each cell. Please advice on what to do. Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONDITIONAL FORMATING
Then use something like
=$B$1-A1=90 where B1 is the cell holding the test date -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kanmi" wrote in message ... Thanks alot for your imput and ideas. The issue is that we cannot specific the date because it change automatically. I mean you can't determine what date it will be. by this formular stating 2012,2,24. it won't work. We have to make reference to whatever date"cell contents" it is according to < , 90days and more than the contents of the cell but we never can determine the content of the cell. Please advice and Thanks once again. "Bernard Liengme" wrote: For the green condition, Formula Is =DATE(2012,2,24)-A1=90 For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<90) For the yellow condition, Formula Is: =A1DATE(2012,2,24) where A1 is the cell you are formatting (or the first cell in a range you have selected for formatting) Your conditional actually missed out "equal to 90DAYS before this date 02/24/12 I included that in the green. Use these to include in the yellow For the green condition, Formula Is =DATE(2012,2,24)-A190 For the yellow condition, Formula Is: =AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<=90) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kanmi" wrote in message ... Please i'm trying to conditional formating the cell and waht to figure out which way is the best way n right formular to use. thanks for your ideas greater than 90DAYS before this date 02/24/12 = GREEN less than 90DAYS before this date 02/24/12 (that is 89days count down to 02/24/12) = YELLOW pass the due date "02/24/12". That is 02/25/12 should turn to RED. I tried to use CONDITIONAL FORMATING BUT i couldn't get the right formular if you have any idea. please let me know. "Note" I want to apply this to row and there are different date on each cell. Please advice on what to do. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) |