Excel Again :)

[Adam]

Is it possible to have it so say for example I highlight any cell on a row, certain cells are highlight on the same row.



Sent from my iPhone using Tapatalk

 

[Oggy997]

Conditional formatting, set rule and apply to a range of cells

 

[Adam]

Is that not just based on what's in that cell. I can do that no problem. I want it to work when you just select a cell or navigate around cells using the keyboard if that makes sense


Sent from my iPhone using Tapatalk

 

[yourcodenameisnick]

I don't get what you're after?
Are these cells empty or do they have values (text or numbers) in them?
Why do you want to do this? (the understanding might help with the answer)

 

[Adam]

Yes the cells could be empty or populated. It's more of a visual thing so when I am in any cell on a given row, three cells of my choosing (within the same row) would be highlight.

I'm guessing it's not something that can be done using CF, maybe a VB code which is beyond me haha


Sent from my iPhone using Tapatalk

 

[Oggy997]

Yes, that can be done,

Can you provide an example of the active cell and the columns you want highlighted (specific offset, specific columns?)

Two examples would be great

 

[Adam]

Ok

Well for example, say I want to highlight cells A1:A3 if I've selected or just even by moving over any other cell in row 1 with the cell selector.

Then the same for row 2, 3, 4, etc

I was just thinking to have cells x1:x3 highlighted by using a red think border or something similar


Sent from my iPhone using Tapatalk

 

[Chrisgti6]

https://www.extendoffice.com/documents/excel/1494-excel-highlight-active-row-and-column.html#a1

This is the closest I can find, but it highlights the whole row/column.

 

[Adam]

Thanks I'll have a look


Sent from my iPhone using Tapatalk

 

[Oggy997]

So you'd want a2:A4 if active cell was row 2, A3:A5 for row 3 and so on?

 

[Oggy997]

Can you not just post a screenshot / illustration