Conditional Format between dates

[pdvsa]

Hello Guru's,

How can I conditionally format the cells below according to the colors?
I have uploaded an image. I tried to paste but the colors do not format.

thank you

 

[jasonb75]

Like this?

Book1
	B	C	D	E	F	G	H	I	J
2	01/01/2020
3	01/12/2023
4	31/01/2026
5	31/01/2046
6
7
8	01/01/2020	02/01/2020	03/01/2020	04/01/2020	01/12/2023	02/12/2023	31/01/2026	01/02/2026	31/01/2046
9
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B9:J9	Expression	=B8=MEDIAN(B8,$B$2,$B$3)	text	YES
B9:J9	Expression	=B8=MEDIAN(B8,$B$3,$B$4)	text	YES
B9:J9	Expression	=B8=MEDIAN(B8,$B$4,$B$5)	text	NO

 

[pdvsa]

wow that is awesome. Have no idea how it works but it does. thank you for the expert assistance!

 

[pdvsa]

Would you happen to have another solution? Conditional formatting doesnt seem to work as I anticipated. I dont know if its a refresh issue. Thank you very much.

 

[jasonb75]

Based on the information that you have provided, there is no reason why it will not work if you have applied it to your sheet correctly.

The alternative is vba, which would work (or not work) in the same way as the conditional formatting as it would be based on the same triggers with the information that we currently have to work with.

 

[pdvsa]

Could the shading be adjusted by 0ne cell? What I mean is could the shading include 1 more cell or 1 less cell? Something like adding a +1 or -1.

thank you.

 

[pdvsa]

or using a formula like this:
=AND($B8:J8>=$B2,$B8:J8<=$B3)
I think it is not correct though (not sure if I can use a range). A formula like this is easier for me to understand and adjust.

 

[jasonb75]

If you're trying to use it in a way that is different to how you have shown in post 1, then you need to show how you are now trying to use it so that we can see why it is not working. The description that you have added in post 6 is meaningless without visual representation.

The answer was correct for the question that you asked, if it is not working for you, then it was not the wrong answer / solution, but the wrong question.