LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Conditional Formatting on a Linked Cell

You didn't tell us what conditional formatting condition you have specified.
Are you using "Cell Value Is", or "Formula Is"? In either case you
shouldn't have a problem, providing that your conditions are using
constants, or cell references on that worksheet. From your description I
would expect that you are using "Cell Value Is" "Greater than" and then your
fixed value, and in that case it shouldn't be a problem.

Also, you didn't say what you mean by "it does not work". What cell values
do you have in the cells which are affecting the conditional formatting?
What result did you expect those to give? What result did you get?

The only problem regarding linking is if you try to use links to another
cell, not in the cell formula as you have told us but in the conditional
formatting conditions. Did you try to do that? If so, what error message
do you get? Doesn't it say something like:
"You may not use references to other worksheets or workbooks for conditional
formatting criteria."?
That means what it says. If you want to use data from another sheet in CF,
the best bet is use a helper cell on the sheet where you want the CF
condition, use that cell to bring the data across from the other sheet, then
use that helper cell in your CF condition.
--
David Biddulph

"clb" wrote in message
...
When I apply conditonal formatting to a linked cell in my spreadsheet it
does
not work. Is there someway to get this to work? I am trying ot get eh
vale
to be bold if it is geater than a fixed value.

The cell link is =UPLOAD!J107 that I am trying to format conditionally.

Thanks



 
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
Conditional formatting linked to another cell Montse Excel Discussion (Misc queries) 1 July 12th 07 03:36 AM
Can you add conditional formatting to columns that are linked? Neall Excel Worksheet Functions 3 June 22nd 07 01:36 PM
Conditional Formatting a Linked Cell Danny Excel Discussion (Misc queries) 2 April 24th 06 09:49 PM
Linked Cell Formatting vman252 Excel Worksheet Functions 1 March 12th 06 02:14 AM
linked cell doesn't show formatting Elizabeth Excel Worksheet Functions 1 March 2nd 05 06:29 PM


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

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"