in excel 2010 what is formula for automatic c

September 12, 2011 at 06:48:18
Specs: Windows 7
I would appreciate some help if possible please.
I have developed a stock control spreadsheet and I would like to automatically highlight in red if one column of calculations is greater than another

I should clarify somewhat:-
b12 is entered as an amount ie £0.75
c12 is a formula i.e. k12*1.75

for example
b12 value from a formula is 10
c12 from a formula is 15
I want to automatically color the 15 into red

Is this able to be transferred to Google Documents as I cannot see any conditional formatting when working with Google docs.

Any help appreciated.


See More: in excel 2010 what is formula for automatic c

Report •

#1
September 12, 2011 at 07:56:07
You should be able to do what you want with either Conditional Formatting or a macro.

Unfortunately, I don't know anything about Google docs, so I can't tell you if either one will work within that app.

However, something about your question doesn't make sense.

You said these 2 things:

b12 is entered as an amount ie £0.75
b12 value from a formula is 10

How can B12 contain both an "entered amount" and the result of a formula?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 12, 2011 at 09:02:27

Hi DerbyDad03

Many thanks for taking time out to try to help me.

"However, something about your question doesn't make sense.

You said these 2 things:

b12 is entered as an amount ie £0.75
b12 value from a formula is 10"

Sorry for confusion I should of course said that c12 was the cell containing the formula. In other words the value 15 is the result of the formula k12*1.75 that sits in the c12 cell.

Hope this makes it better to understand.

In conditional formatting I can only see a condition where the value of a cell is a known quantity. I want to enter a value in k12 which sends a calculated result to c12 which is then compared to b12 to see which is the greater amount.

Difficult to explain without showing whole spreadsheet.

Any further help appreciated.

Dave


Report •

#3
September 12, 2011 at 14:22:04
You would simply use a Conditional Formatting Rule to Conditional Format the cell.

A Rule is a formula that must evaluate to either TRUE or FALSE. When it's TRUE the formatting will be applied.

In your case, you would use 2 Rules, one checking to see if B12 was greater than C12 and another checking to see if C12 is greater than B12. Only one of them can be true at the same time, so the format will only be applied to one cell.

=B12>C12
=C12>B12

Read up on Condtional Formatting in the Help files.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
September 13, 2011 at 00:43:32
Again Many thanks for your help I will apply the conditional formatting to my spread sheet but having a look at Google docs although you can insert a formula into a cell you cannot do conditional formatting as Google Docs is not really excell it simply reads an Excel file.

Thank you for taking time out I always appreciate when people are kind enough to try to help.

cheers

Dave


Report •

Ask Question