I have dates written into range H3:BE3
I have dates writen in BF8:DG8
I would like a condditional format formula that colours individual cells in the range H8:BE8, if a cell in the range H3:BE3 is the same as a date in BF8:DG8.
In other words, let's say H3 has the same date as BF8, then cell H8 would be coloured black, otherwise, not coloured at all.
What would I type in the formula box of conditional format (by formula) for this ?
Kind regards,
Chris
I have dates writen in BF8:DG8
I would like a condditional format formula that colours individual cells in the range H8:BE8, if a cell in the range H3:BE3 is the same as a date in BF8:DG8.
In other words, let's say H3 has the same date as BF8, then cell H8 would be coloured black, otherwise, not coloured at all.
What would I type in the formula box of conditional format (by formula) for this ?
Kind regards,
Chris