Help, IF with 2 Conditions, Then, Else, only works if I have 1 condition

Cendrinne · #5 09-26-2021, 12:40 AM

Quote:

Originally Posted by gmayor

You need

Code:

If aTbl.Rows(1).Range.Font.Color = 192 And aTbl.Rows(1).Range.Font.Bold = True Then

P.S.It appears Andrew and I were replying at the same time. Either will work.

I'm so happy you wrote it that way too, cause I'm certain I was so close at one point. I kept getting error message or it just didn't do anything. I might have had a typo, cause I remember using And, and the long way vs the way Andrew wrote it.

Both are great and I'm very greateful you help as well.
Like I told Andrew, I'm getting better, but still lot's to learn.

Thanks so much for guiging me, Graham.

Cendrinne

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumProduct with OR condition	ShostyFan	Excel	7	10-16-2019 02:19 PM
If condition not working.	jhansrod	Word VBA	8	06-15-2019 05:59 AM
How to use if condition to for this ...	LearnerExcel	Excel	1	12-19-2016 02:14 PM
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
check with condition	karti	Word	2	03-15-2011 06:06 AM