Dave Punky
Board Regular
- Joined
- Jan 7, 2010
- Messages
- 133
Hi all,
I'm trying to use some conditional formatting and I'm not sure how to code it, as I can't seem to get it to work.
Basically what I want to do is if there's a 1 in a perticular cell, a set of cells in the row underneath change colour, if there's a 2 then two rows worth change colour - if you see what I'm saying.
For example, the ranges I'm working with would be say B12:G12 for line 1. If the number 1 was entered in G12, then range B13:G13 would change colour. If a 3 was entered then it would be range B13:G16.
I'm pretty sure I would need to use conditional formatting for this, but I'm not sure how to proceed. Any advice would be appreciated.
I'm trying to use some conditional formatting and I'm not sure how to code it, as I can't seem to get it to work.
Basically what I want to do is if there's a 1 in a perticular cell, a set of cells in the row underneath change colour, if there's a 2 then two rows worth change colour - if you see what I'm saying.
For example, the ranges I'm working with would be say B12:G12 for line 1. If the number 1 was entered in G12, then range B13:G13 would change colour. If a 3 was entered then it would be range B13:G16.
I'm pretty sure I would need to use conditional formatting for this, but I'm not sure how to proceed. Any advice would be appreciated.