I've been trying to use conditional formatting with a formula to achieve the following.
If a P is included in a one of the dated cells then it turns the related event cell blue. At the moment I can only work it when P is inputed on column I but I'd like it to work across columns I to RW
I know at the moment that the formula is only set to column I, but that is because everything I've tried doesn't seem to work and I thought I'd at least give an example of what I'm looking for. Basically it is to replicate what is happening in column I across the following columns.
Thanks
Paul
Bookmarks