LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Danny
 
Posts: n/a
Default Conditional Formatting a Linked Cell

I have a cell on sheet 2 that is linked to a cell on sheet 1 of the same work
book.

When the cell is empty on sheet 2 (i.e. no entry on the link in sheet 1), I
would like the cell on sheet two not to have a fill color. If the link comes
back with values I would like to have the fill be a certain color.

Reading through several posts I have tried using conditional formats as
follows with no luck:

1. cell value
is not equal to
=""

2. Also tried many isblank, is not blank

Thanks,

Danny

 
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
Applying conditional formatting to cell based on another cell's in kdesemple Excel Discussion (Misc queries) 1 March 22nd 06 06:37 PM
Conditional Formatting to Test Value in Cell Carroll Excel Worksheet Functions 3 March 9th 06 07:38 PM
Conditional Formatting For A Cell Other Than The One With The Form Jim J. Excel Worksheet Functions 2 February 19th 06 07:11 PM
Transfer Cell Formatting for linked cells Scott Excel Discussion (Misc queries) 2 November 23rd 05 11:04 PM
enhanced conditional formatting Stuart Excel Discussion (Misc queries) 13 November 13th 05 07:20 PM


All times are GMT +1. The time now is 01:53 PM.

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

About Us

"It's about Microsoft Excel"