i need help pls....
scenario,
i am using excel 2010
i have columns startdate, enddate, duration and max. holidays.
in start and end date we can input dates then duration automatically calculated between two dates and give the result like 2days or 3 days etc, max holidays contain drop down list containing 30 and 40
now,
my problem to sort out is i want to conditional format duration by rows giving color band for number of days in the timeline i made which has 45 numbers to it
when user selects 30 it should check with duration and max holidays to give green red color respectively
i want to send my xls file but how to??
scenario,
i am using excel 2010
i have columns startdate, enddate, duration and max. holidays.
in start and end date we can input dates then duration automatically calculated between two dates and give the result like 2days or 3 days etc, max holidays contain drop down list containing 30 and 40
now,
my problem to sort out is i want to conditional format duration by rows giving color band for number of days in the timeline i made which has 45 numbers to it
when user selects 30 it should check with duration and max holidays to give green red color respectively
i want to send my xls file but how to??
