Coloring 3 cells based on condition in 1

Hi

im trying to get a code for 3 different scenarios

Range will be something like A4:K4
For each cell in range

1. If cell value < 0, then color that cell and the two cells below it
2. If cell value = 0, then color that cell, the one above, and the one below
3. If cell value > 0 , color that cell, and the two cells above it

these will be in separate macros so dont worry about which scenario takes precedence,

If cell.value = 0 Then
cell.interior.colorindex = 9

'now what do i do, i need to color 2 more cells...

thanks

Here is one way:

Please Login or Register  to view this content.

Thanks Stephen, nicely done.

thats a very useful link there Roy, cheers!