LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Trying to get contents of cell linked through IF function.

Dave,

That worked. Thanks!!!

"Dave" wrote:

Hi,
I don't think you can use a function to do anything else except return a
formula.
However, in your example, you could perhaps use conditional formatting.

In the formula cell, open the CF window, select Formula Is, then:
Condition 1 =B1 and select format conditions identical to B1
Condition 2 =B2 and select format conditions identical to B2

Regards - Dave.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use of the Contents of a cell as a worksheet name in a function tooMuchFun Excel Worksheet Functions 3 July 3rd 07 04:39 AM
Excel 2003 cell contents truncated when linked into Word? Jeff Henrichs Links and Linking in Excel 0 November 8th 05 04:32 AM
linked cell contents not autofitting row height joeeng Excel Discussion (Misc queries) 5 August 2nd 05 07:58 PM
Contents of adjacent cell from a function Nick Excel Worksheet Functions 5 July 8th 05 04:28 PM
Function to operate on ink linked to cell Alan T Excel Worksheet Functions 0 November 20th 04 10:03 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"