Setting conditional colours for cells
 

Hi all, I have used the max 3 conditional formatting choices for setting cell
colours dependant upon value, but I need additional options.
I thisnk this can be done using macros but does anyone know the
formula/script?

My request is simple, I need all cells with H or H/2 to be yellow, U or U/2
to be red, & L or L/2 to be green (these have been set via conditional
formatting) however I also need V & V/2, F & F/2 and C & C/2 to have colour
formatting which I cannot apply without some manual formatting.

All help would be greatly appreciated :)
Thanks in advance.

Setting conditional colours for cells
 

Hi all,

Think I may have cracked it :)
Thanks for looking :)



"Loosey" wrote:

Hi all, I have used the max 3 conditional formatting choices for setting cell
colours dependant upon value, but I need additional options.
I thisnk this can be done using macros but does anyone know the
formula/script?

My request is simple, I need all cells with H or H/2 to be yellow, U or U/2
to be red, & L or L/2 to be green (these have been set via conditional
formatting) however I also need V & V/2, F & F/2 and C & C/2 to have colour
formatting which I cannot apply without some manual formatting.

All help would be greatly appreciated :)
Thanks in advance.

Setting conditional colours for cells - now solved?
 

Hey all,
Think I have solved this now :)
Thanks



"Loosey" wrote:

Hi all, I have used the max 3 conditional formatting choices for setting cell
colours dependant upon value, but I need additional options.
I thisnk this can be done using macros but does anyone know the
formula/script?

My request is simple, I need all cells with H or H/2 to be yellow, U or U/2
to be red, & L or L/2 to be green (these have been set via conditional
formatting) however I also need V & V/2, F & F/2 and C & C/2 to have colour
formatting which I cannot apply without some manual formatting.

All help would be greatly appreciated :)
Thanks in advance.