LinkBack URL
About LinkBacks
Hi
I need to use conditional formatting to turn cell red, amber or green if previous three cells are not
populated and green if they are.
Any suggestions please : ))))
Hi
I need to use conditional formatting to turn cell red, amber or green if previous three cells are not
populated and green if they are.
Any suggestions please : ))))
maybe like this:
1) Highlight F6:F233
2) Apply this conditional formatting rule:
=OR($L6,$M6,$N6=0)
...color red.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks, however this is making the the whole column red. Any other suggestions?? : )
You don't say what previous means. Is it the three above or the three to the left in the same row?
Why do your formulas look at columns L, M, N, which are empty?
My attachment looks to the left of column F.
Last edited by protonLeah; 09-15-2013 at 08:27 PM.
Ben Van Johnson
Hi
It refers to the 3 to the left C, D and E. So basically if 1 is populated then red, 2 then amber and all three green. Do you think this is possible, would be a huge help!! : )
So, change the formula I gave you to reference those columns instead of L, M and N, which is what you had in there originally.
Thank you!! This really helps : )))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks