Highlights several cell based on single cell value (on the same raw) , vba

[dainova]

Is it possible to do thru vba:

1. Check all column F:F for value 'xxx'
2. If let say F17 = 'xxx' then highlight C17:F17 (several cell in this row).
3. Continue till the end of values in F:F, could be multiple 'xxx' on this raw

I tried to work/record this thru macros conditional formatting but failed,

Thanks to all gurus.
Best
Dai

[stnkynts]

try:

Please Login or Register  to view this content.

[FDibbins]

You could do this with regular Conditional Formatting, you dont need VBA.

1. highlight the range you want to apply the conditional formatting to (C1:F1000) I would not suggest you use entire columns for the range, it becomes very resource-intensive
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =$F1="xxx"