VBA code to color cells based on 5 cells values

[MoeMuny]

Hi everyone...

New here and kinda new to VB as well, and I need a little help...

I have 5 cells in one row that are all either true or false.
I need to make sure that in these 5 cells only one of them is returning a True also that least one of them is returning a true.
If there is more then one true or if none are true I want to turn the A1:A3 cells red

Here is what I have... I and its not working so I know it not right

Please Login or Register  to view this content.

Any help is greatly appreciated

thanks in advance!!!

[Winon]

Hello MoeMuny,

Wellcome to the Forum. I noticed that you have posted your thread without complying with the Forum rules,
where it is clearly stated how you should post any Code.

Leith Ross was kind enough to do it for you this time, but please abide by the rules of this Forum. Thank you.

Instead of Code, why don't you just use Conditional Formatting. If you could upload a sample WorkBook, we could help you with that.

[MoeMuny]

Winon,
As I said, I'm new here and I don't know how to post the code tags, I will look into it for future posts.

Thanks Leith Ross for helping a newb out!!

Conditional formatting will not work for me in this situation it needs to be in VBA, but thanks!

I have been able to get the first part working with this formula

Please Login or Register  to view this content.