View Single Post
 
Old 09-26-2021, 12:40 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2019
Competent Performer
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 190
Cendrinne is on a distinguished road
Red face Hello Graham, yes I've tested yours too, wonderful :) Works great too

Quote:
Originally Posted by gmayor View Post
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
Reply With Quote