Please please help me as I am new to this and would really like to be better. I have attached what I have doubts about please help
Please please help me as I am new to this and would really like to be better. I have attached what I have doubts about please help
using the cell that has contract end date - BUT this cell must have a valid date in and not text
select the columns A2:D1000 (or however many rows you are likely to use)
Then in conditional format
set up three rules - using formulas
=$B2>= date(year(today()),month(today())-6,day(today()))
format as Red
=$B2>= date(year(today()),month(today())-9,day(today()))
Yellow
=$B2 <= date(year(today()),month(today())-10,day(today()))
Green
and put in that order in the formulas on conditional formatting
and stop if true
Rather than a word document - load up an excel spreadsheet
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
Last edited by etaf; 04-27-2015 at 08:51 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks