Conditional Formatting Help?

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.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Dave Punky

Board Regular
Joined
Jan 7, 2010
Messages
133
Hi Fazza,

I'm not really having much luck using that, I'm guessing I'm going wrong somewhere - also that look like it does the whole row rather than a selection, which I can add into the first set of brackets I imagine?
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
I don't know what you're doing, so can't advise on if it is wrong. Maybe search on line for examples of applying conditional formats. Or refer to Excel help.

It doesn't do a whole row. Only the cells you format. The posted formula is fine.
 

Dave Punky

Board Regular
Joined
Jan 7, 2010
Messages
133
Ok I understand where I was going wrong originally, and the formula you provided is now working - which is appreciated!

I know my description wasn't all that clear, so I knocked up some images which kinda show exactly what I want to do.



I'm gonna have up to 100 rows in place, I'm thinking there must be a way where I can set a rule to look at row H and if there's a digit, drop down a line and highlight - otherwise I'm gonna be applying a lot of rules to each set of rows lol!
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,368
Well, it is a little clearer - though still not enough (for me).

What you want can be done, for sure. Exactly what you want isn't clear enough for me to give a specific answer. I could make some assumptions, but I'd rather not. OK?

cheers
 

Dave Punky

Board Regular
Joined
Jan 7, 2010
Messages
133
I don't think there is any better way of explaining it, that is exactly what I want to do in the picture, lol.

Basically I'm logging reference numbers and if I'm inturrupted, I want the case where I'm inturrupted to highlight, and if I'm inturrupted more than once for however many lines to drop down.

Maybe there is another way without conditional formatting or a more effective way of doing this?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,249
Messages
5,576,947
Members
412,753
Latest member
Coach_Olson
Top