Highlight a cell if it falls between 2 week numbers

[NORRILLOUS]

Hello,

I am working on a file that a user will enter a start date and a finish date. I am trying to make the file decide which cells to shade based off its value.

=IF($E4="","",IF(G$3>=$E4,-1,1)*IF(G$3<=$F4,1,-1))

and I have my conditional formatting set to change the value 1 to blue.

It would be easier to explain if I could show you the file.

 

[Special-K99]

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

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[NORRILLOUS]

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

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

Thanks, But I cant install anything to get it to work.

 

[NORRILLOUS]

Hello,

I am working on a file that a user will enter a start date and a finish date. I am trying to make the file decide which cells to shade based off its value.

=IF($E4="","",IF(G$3>=$E4,-1,1)*IF(G$3<=$F4,1,-1))

and I have my conditional formatting set to change the value 1 to blue.

It would be easier to explain if I could show you the file.

Here is a Image if any one would like to look at it. https://www.dropbox.com/s/w9fpz57chkg5xwk/EXCEL SS.png?dl=0