PC Review


Reply
Thread Tools Rate Thread

auto/conditional formatting

 
 
willemeulen
Guest
Posts: n/a
 
      7th May 2009
have the following sheet:

Column A = value inserted by user
Column B = value inserted by user
Column C uses index function using column A + B to return a formula
The next 5 columns (D-H) will have additional values, when filling out the
form these cells will be empty and will be inserted by the user.

My goal is that excel automatically gives the cell a shade/color/marking etc
when a value needs to be added.

Example:

Column C

=(D12+E12)/3 * F12 --> I want Excel to shade cells D12,E12 and F12

=(D13*3.14)/G13 *H13 --> I want Excel to shade cells D13,G13 and H13

Now it is easy to see which cells require a value to be inserted by the user
or when a value is missing.

Is this possible with conditional formatting using a formula? Or do I need
to use VBA :-( (don’t have any knowledge of VBA). It should be possible; I
mean the trace precedents tool shows you all cells used in a formula/cell.

Thanks,

Willem


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting causing auto complete to deactivate? bobby769 Microsoft Excel Misc 3 1st Mar 2010 01:06 AM
Conditional Formatting for a Column Chart and Auto Shape Amanda Microsoft Excel Misc 8 10th Jun 2008 03:23 PM
Conditional Formatting No Longer Conditional in 2007 Beta =?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?= Microsoft Excel Crashes 0 17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula Ray Stevens Microsoft Excel Discussion 7 12th Mar 2006 10:24 PM
Auto Sum + Conditional Formatting =?Utf-8?B?QmVuSkFNTUlO?= Microsoft Excel Misc 5 15th Jun 2004 05:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:06 PM.