macro-filter

[hanzsolo]

I want to run a macro that is based on a condition (if the value in the cell = 1) that if it's true, will change the color of the entire row. If it's not true, then it won't change the color of the cell.

 

[3link]

I want to run a macro that is based on a condition (if the value in the cell = 1) that if it's true, will change the color of the entire row. If it's not true, then it won't change the color of the cell.

You don't need macros for this. Conditional formatting should do the trick. What version of excel are you running? (what year?)

 

[3link]