ohhaykfrankk
New member
- Joined
- Jan 29, 2017
- Messages
- 33
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hey everyone!
Is there a way to change the cell color by using a formula or a macro?
If not, maybe a formula that I can make a conditional format out of like bold or something. It just doesn't work because all numbers over 0 can be either green or red and it's just a lot of work to manually color them.
If so, this is what I'm looking for:
Cells with numbers (most cells are blank) in Columns I, K, M need coloring.
So search H8 (e.g) and find it in C2:C49 (for e.g. we'll say C27 has the text in H8)
When found, if the number in G(27) is 0, color I8(e.g.) green. If the number of G(27) is <0 (or =/0 whichever) then color I8 red.
If it matters, there's also numbers in IKM that are 0 that can stay blank colored because they don't exist in column C.
I hope this makes sense.
Is there a way to change the cell color by using a formula or a macro?
If not, maybe a formula that I can make a conditional format out of like bold or something. It just doesn't work because all numbers over 0 can be either green or red and it's just a lot of work to manually color them.
If so, this is what I'm looking for:
Cells with numbers (most cells are blank) in Columns I, K, M need coloring.
So search H8 (e.g) and find it in C2:C49 (for e.g. we'll say C27 has the text in H8)
When found, if the number in G(27) is 0, color I8(e.g.) green. If the number of G(27) is <0 (or =/0 whichever) then color I8 red.
If it matters, there's also numbers in IKM that are 0 that can stay blank colored because they don't exist in column C.
I hope this makes sense.