ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Click in cell w/ formula and get colors in referenced cells (https://www.excelbanter.com/excel-discussion-misc-queries/55047-click-cell-w-formula-get-colors-referenced-cells.html)

albean

Click in cell w/ formula and get colors in referenced cells
 

Hi,

When you click in a cell with a formula, Excel will then put colors
around the cells that are referenced.

Somehow I turned that feature off. Now I do not get colors in the
other cells. Where is that option to turn it back on???? I've looked
and looked but I just can't find that option.

Thanks for the help.


--
albean
------------------------------------------------------------------------
albean's Profile: http://www.excelforum.com/member.php...o&userid=28751
View this thread: http://www.excelforum.com/showthread...hreadid=484362



All times are GMT +1. The time now is 07:51 AM.

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