Conditional Formatting of one based on the other cell. Closed

Question

Hello, 

I was wondering if there is a way I can say to excel without coding:

1)IF cell A1 is equal or greater [equal or less] than cell B1, then color cell A1 RED, otherwise no format.

2) Also, is it possible to do double formatting --> If cell A1 is equal or greater than cell B1, then color cell A1 RED, otherwise If cell A1 is equal or less than cell B1, color cell a1 GREEN, otherwise no format.

I would much appreciate your help!


Configuration: Windows / Firefox 41.0

TrowaD · Answer

Hi Dimi,

Your statements are confusing.
"equal or greater [equal or less]" uhm ..... which one is it.
Also both statements use equal, this doesn't mean that when A1 and B1 are the same that the cell will be half red and half green (would be cool though). If the first rule is true, then CF doesn't look at the second rule.

Formula's used:
=A1>=B1 ; --> red
=A1<B1 ; --> green

Best regards,
Trowa
 
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.

TrowaD · Answer

Hi Dimi,

That makes more sense, but the formula's won't change that much.

Formula's:
=A1>=B1 ; --> red 
=A1<=C1 ; --> green 

Best regards,
Trowa

Conditional Formatting of one based on the other cell.

2 responses

Similar discussions

Subscribe To Our Newsletter!