Hi Dream Team,
Hoping to get some assistance.
I am conditional formatting using the following formula:
=AND($C7="Specialist",J$6>=$E7,J$6<=$F7)
This currently does what I need it to do, with the the relevant highlighted cells turning the right colour based on my customised format.
However I'd like to add one further detail and i'm stuck....
Is there a way to amend my formula, so that the relevant highlighted cells can also contain whatever text is within cell $D7
Any help would be truly appreciated.
All the best,
Hal
Hoping to get some assistance.
I am conditional formatting using the following formula:
=AND($C7="Specialist",J$6>=$E7,J$6<=$F7)
This currently does what I need it to do, with the the relevant highlighted cells turning the right colour based on my customised format.
However I'd like to add one further detail and i'm stuck....
Is there a way to amend my formula, so that the relevant highlighted cells can also contain whatever text is within cell $D7
Any help would be truly appreciated.
All the best,
Hal