Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?

i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.

Cheers

Rich

No, you cannot change colours using standard worksheet functions - you
would need to use VBA.

Sorry,

Pete

On Mar 23, 3:27 pm, "Richhall" wrote:
Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?

i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.

Cheers

Rich

On 23 Mar, 18:17, "Pete_UK" wrote:
No, you cannot change colours using standard worksheet functions - you
would need to use VBA.

Sorry,

Pete

On Mar 23, 3:27 pm, "Richhall" wrote:



Without using VB is there a way to create a condition based on a cell
colour, i.e if Cell A3 is grey but cell A1: A8 (excluding A4) is
green, then create a condition in B1:G8 that if any of the cells A1:A8
are grey, that the corresponding cells in that row go grey also?

i.e if A3 is grey B3:G3 go grey. If As then goes green, B3:G3 go
green too. If A8 is then grey, then B8:G8 go grey.

Cheers

Rich- Hide quoted text -

- Show quoted text -

Would you able to give me a started for how I would use VB please? I'm
familiar with macros and very simple VB code.

Cheers

Rich