Jagdev Singh
Active Member
Hi Experts
I am stuck with one query and won’t able to find the remedy for it. I want to apply conditional formation on a particular header name (“Year”) in the sheet. The issue is it keeps on changing its location in the sheet.
My CF formula is
=Isnumber(Find(“Total”,$B1))
Instead of $B1 is it possible to track the header first and then use it in its place.
Regards,
JD
I am stuck with one query and won’t able to find the remedy for it. I want to apply conditional formation on a particular header name (“Year”) in the sheet. The issue is it keeps on changing its location in the sheet.
My CF formula is
=Isnumber(Find(“Total”,$B1))
Instead of $B1 is it possible to track the header first and then use it in its place.
Regards,
JD