nitrammada
Board Regular
- Joined
- Oct 10, 2018
- Messages
- 78
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
I'm looking for code that does the following and would appreciate any help you may have.
My table has 24 rows of data, column A I have 6 heading types, H1 through to H6.
Each row has its own heading type.
I'm looking for code that will search column A, when it finds the particular heading type, do the following:
H1 - leave the font colour black
H5 - change the font colour to red
H3 - change the font colour to pink
H4 - change the font colour to cyan
H5 - change the font colour to green
H6 - leave the font colour black
Below is a snap shot of my data set. I have set this up as a sample to explain what I'm after.
If I can find code that works I will apply to my actual database that 1000's of rows.
But for now if I can understand how the code works it would be a great help.
Any assistance would be greatly appreciated.
Thanks in advance.
I'm looking for code that does the following and would appreciate any help you may have.
My table has 24 rows of data, column A I have 6 heading types, H1 through to H6.
Each row has its own heading type.
I'm looking for code that will search column A, when it finds the particular heading type, do the following:
H1 - leave the font colour black
H5 - change the font colour to red
H3 - change the font colour to pink
H4 - change the font colour to cyan
H5 - change the font colour to green
H6 - leave the font colour black
Below is a snap shot of my data set. I have set this up as a sample to explain what I'm after.
If I can find code that works I will apply to my actual database that 1000's of rows.
But for now if I can understand how the code works it would be a great help.
Any assistance would be greatly appreciated.
Thanks in advance.