Is there a function that can color a block if that block is higher than another block?

**Apparas** · 10-08-2012, 05:43 PM

The title pretty much says it all.
Thank you in advance!

**TMS** · 10-08-2012, 05:45 PM

Not quite sure what you mean by "block" but sounds like you're looking for CONDITIONAL FORMATTING.

Regards, TMS

**Apparas** · 10-08-2012, 06:22 PM

I mean a square like A1 or B5. I'm looking for a method to compare results (for example football results).
If I have these columns :
A B
5 1
2 0
1 3
2 1
Than I would like for A1,2 and 4 to automatically receive a green color (BG not text).
I'm not familiar with the function last mentioned.
Kind regards,
Apparas.

**TMS** · 10-08-2012, 06:26 PM

Conditional Formatting: =A1>B1 format as green.

Regards, TMS

**Apparas** · 10-09-2012, 10:21 AM

Thank you for your quick reply. This worked for once cell at a time. However, I'm wondering if I can apply this to a whole column? I have not yet found a way to achieve this.
Kind regards,
Apparas.

**TMS** · 10-09-2012, 10:44 AM

Select the whole column first, starting with cell A1. Then apply the CF.

Regards, TMS

Is there a function that can color a block if that block is higher than another block?

LinkBack

Thread Tools

Rate This Thread

Display

Is there a function that can color a block if that block is higher than another block?

Re: Is there a function that can color a block if that block is higher than another block?

Re: Is there a function that can color a block if that block is higher than another block?

Re: Is there a function that can color a block if that block is higher than another block?

Re: Is there a function that can color a block if that block is higher than another block?

Re: Is there a function that can color a block if that block is higher than another block?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions