Cf based on first column

[CDandVinyl]

I'm trying to have conditional formatting operate when column E is the leftmost column on the sheet.

So if E is the first column showing , apply the CF. If it isn't (some other column is leftmost) then don't.

I'm not sure this is even possible with CF , but am grateful for any advice.

[mehmetcik]

I think it is possible. but there must be data in a row columns A to D. Header Text Will do.

Sorry that only works for rows, =SUBTOTAL(103,$A1:$D1) will return 4 if all 4 rows are visible and 0 if they are hidden.

You will need a Userdefined function to to give the same functionality for columns.

Then you will need to test it with conditional formatting.

[CDandVinyl]

Yes , A - D all have data and headers.

[mehmetcik]

You need to paste this code into a macro module:

Please Login or Register  to view this content.

Then use the Conditional Format rule: =vcol(D1)=4 for Column E

[CDandVinyl]

Ok Thanks for this.