Hello,
Is it possible to have a macro to have the text colour of a range of cells a particluar no. of columns to be the same text colour as their adjacent target cells?
E.g.
Column A = target cells
Column D, E & F = adjacent cells for text colour to be changed
If text colour of a cell in column A is white (cell A3), change the adjacent cells of column D, E & F (cell D3, E3 & F3) to be white text too. If the text colour of a cell in column A is black (cell A2), change the cells of column D, E & F (cell D2, E2, & F2) to be black text too.
Anyway, I wanted a macro instead of other methods (if available) because this is code will be combined into my final macro for the final database.
I've a sample data attached. Please advise. Thanks.
Bookmarks