Lawrence429
New Member
Hello all my Excel geniuses
I am tracking what tool is used each day. I have a cell that I put a tool ID number in everyday, if the tool changes the number changes and I would like the cell to change color if it is different from the cell in the previous column.
(There are actually 38 different machines all listed in column B that I need to compare with the previous day. If I can figure out how to do one row, I assume it would be copy the formula down to all rows below).
thank you in advance
Lawrence
PS if VBA is preferred, please share the text as I am not that good with VBA
I am tracking what tool is used each day. I have a cell that I put a tool ID number in everyday, if the tool changes the number changes and I would like the cell to change color if it is different from the cell in the previous column.
(There are actually 38 different machines all listed in column B that I need to compare with the previous day. If I can figure out how to do one row, I assume it would be copy the formula down to all rows below).
thank you in advance
Lawrence
PS if VBA is preferred, please share the text as I am not that good with VBA