Hi All,
I would like to have macro that highlight the row base on condition below:
Example:
if the cell column D contain X1, then highlight the row with light yellow
as attached file below
Hi All,
I would like to have macro that highlight the row base on condition below:
Example:
if the cell column D contain X1, then highlight the row with light yellow
as attached file below
Unless you have a really huge table, you dont need VBA for this, Conditional Formatting will give you what you want.
1. highlight the range you want to apply the conditional formatting to (=$A$8:$AL$19 in your sample)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$D8="X1" format fill as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have try it, but when i delete all rows, and put some new data, then i have to do Conditional Formatting again
how can i do?
When you delete the entire row, then you romove the row completely, and delete everything in it. Rather than delete the row, delete the cell contents
vba
To a sheet module
Please Login or Register to view this content.
Hi Jindon and All,
That what i need, now is working with the sample,
can i ask for more help, if i change the condition like... number such as 590, 580, 570 Etc..
it the row is not high light, it is possible to make it flexible?
Sample file attached below:
please help
please help
Don't understand what you are trying to do.
Hi Jindon,
Need to use the condition to highlight the row,
If cell in column D, contains base on conditions, then highlight ROW, when i change to other condition such as number, alphabet, it not change
please see the sample file below:
Hi Jindon,
Need to use the condition to highlight the row,
If cell in column D, contains base on conditions, then highlight ROW, when i change to other condition such as number, alphabet, it not change
please see the sample file below:
Try formatting your cells E2:E5 and D8:D19 as number.
Hi John,
I have try to change formatting to number, but result still the same, not change
how can i do?
This works for me on your sample.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks