Forum Discussion
Auto color fill rows when condition met using a VBA or MACRO.
I have been modifying a process sheet for my work, to stream line a few parts and make some of it automatic so it takes less time to create. I would like to have it highlight a range of cells in a ro...
enuff_2live With Conditional Formatting, create a rule:
=$B16="X"applying to the entire range:
$B$16:$G$45A file with a working example is attached.
Riny_van_Eekelen That almost worked, except if you copy any of the cells the formatting gets changed. Is there a way to lock the formatting to the cells that I want to be formatted? Or is there a VBA code that might help in this instance? I need to make this as dummy proof as possible. I can't lock the cells do to the fact that the are were anyone can enter the data. Thank you for the help.