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 anotherI should clarify somewhat:-

b12 is entered as an amount ie £0.75

c12 is a formula i.e. k12*1.75for example

b12 value from a formula is 10

c12 from a formula is 15

I want to automatically color the 15 into redIs this able to be transferred to Google Documents as I cannot see any conditional formatting when working with Google docs.

Any help appreciated.

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 10How 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.

Hi DerbyDad03Many 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

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>B12Read up on Condtional Formatting in the Help files.

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

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

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History