ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell colors (https://www.excelbanter.com/excel-discussion-misc-queries/72458-cell-colors.html)

CBrausa

Cell colors
 

I have a master sheet, sheet 2 has this formula in the cells,
=IF(LEN(VLOOKUP($A33,'FD RUN LIST -
MASTER'!$A$12:$O$587,$B$24,FALSE))=0,"",(VLOOKUP($ A33,'FD RUN LIST -
MASTER'!$A$12:$O$587,$B$24,FALSE)))

Is there some way to make the cells on sheet 2 change color if the
master has been altered in any of the cells?


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513874



All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com