Hi,

On my worksheet, Group or Individual Run Charts, I have a range of cells:C5:AD16 with data

Within this range, c7:ad7 are numbers representing Fiscal Weeks (FW)

In Cell C4, I have the current FW represented:

On other worksheets, this format worked well, but for whatever reasons, it's not working as intended on this worksheet.

I attached an example file. Please check out, Group or Individual Run Charts & tell me why the conditional formatting is not working. Or, more importantly, get the current FW columns highlighted.

Thanks