Getting total of dates if it is more than two / CF to generate Odd Numers and Even numbers

[VDS]

Dear All,

I attach herewith excel file with two parts

Part 1 gives the list of dates where I have calculated the number of delays between two dates by Days360() and taken Sum in Colum D. What I require the result 83 should come in Column C (with formula) against Total number of Delays as per Column B in months and days and Column D to be deleted.
PART 2 gives generating auto numbers with MAX function. in Column B I have Generated TRUE/FALSE with ISODD() and marked GREEN for True and RED for FALSE with Conditional Formatting. Here, the same CF to be applied for serial numbers without Column B so that any number generated will show with colour automatically.

Help is requested.

 

[Nebu]

Hi:

Please find the attached.

Thanks

 

[Khalid NGO]

Hi VDS,

Part-2 can be done with just 1 CF, for example:

1) Select your range (A25:A44) Fill cells with Red color
2) Go to conditional formatting
3) Formula
4) =ISODD(A25)
5) Format > Fill Green
6) OK

Regards,

 

[VDS]

@Dear All,

Thans a lot for your replies.

vds

 

[VDS]

@Khalid,

Dear Friend, Few more doubts. The question asked is incorrect.

PFA the revised excel file. I am putting a number say 100 in B2 and generating the serial numbers with Max function. Any number in B3 will be +1 of B2. and so on. If any row is deleted, sequence of the remaining numbers should not be disturbed. If the number in B3 is odd (say 101), it should be filled with RED and B4 should be filled with GREEN upto any specified range. After applying the CF with the current Max Function, colouring will also be changed in the corresponding columns for both odd numbers and even numbers while deleting the rows as per the user entry. Hope the question is clear. Fill colour is needed only in the number columns.

VDS

 

[Khalid NGO]

Hi VDS,
Please this file, and confirm I've understood your query or not

I have used the same procedure as mentioned in Post # 3.

Regards,