Conditional Formatting or VBA Code for 2 different colors for column and row selected cell in a data range

[Oh!Calcutta]

I want Conditional Formatting formula or VBA Code for setting 2 different colors for column and row of a selected cell in a data range. I am using Office 365.

 

[bebo021999]

Could you upload an image/snapshot to see how the sheet look like?

 

[Oh!Calcutta]

Could you upload an image/snapshot to see how the sheet look like?

Yes of course.