Formatting

[Peravali Satish]

Hi,

Can any one tell me how to do conditional formatting for below scenario.

I defined start date and finish date in cloumn c&d. I have a year calender starts from column J where as I defined calendar dates in Row3. Now with respective to column c & d dates, automatically XX to YY column should highlight.

Thank you in advance.

 

[Special-K99]

Somewhat unclear.

You have a list of dates in column J beginning at row 3?
And you want to highlight those dates if any of them are in range defined by the start and finish dates in column C and D?
The dates in column C and D are only in one row, for example row 2?
Is that correct?

If not post a sample of the spreadsheet, include cell references and expected output.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[Fluff]

Select J4 to the end of the data & use this formula
=AND(J$3>=$C4,J$3<=$D4)