Conditional Formatting: Comparing cell with a column of values and applying 3 rules

Hi guys,

I am looking to set rules so that each cell in a column is compared to one specific cell value and then traffic light rules are applied to the values in the column, eg Higher than x = green, equal to x = amber and lower than x = red.

However, I have many columns so I would need help with finding the right formula to do this!

Also, the specific cell value is not regular, so could be 3 in one column and 4 in the next column. So it can be refered to as value x.



Thanks in advance!
=)

Abdi

Maybee like this:

Originally Posted by Rambo4711

Maybee like this:

Yep that does the trick!

Thanks.

I am also looking at a another set of requirements.

I3 Rules, EDIT.xlsxf you can have a look, my Formula may not be simple enough for the rules!
I'm also trying to include this into one rule, so that it is faster to apply for each column, instead of 3X Rules for 1 column!

These are the formulae I used:

1 =IF(AND(A$1>=A2;A2>0); A2) = GREEN

2 =IF(AND(A$1<A2;A2>0;A$1>0); A2) ORANGE

3 =IF(AND(A$1=0;A2>0);A2 ) RED


Please have a look
:-)

The CF rules is quite OK.

Remember that if you have defined CF rules in a cell in one column (without absolute references to columns), you can apply the same rule to other cells in other columns by copying the format from that cell (or use the paintbrush).

Originally Posted by Rambo4711

The CF rules is quite OK.

Remember that if you have defined CF rules in a cell in one column (without absolute references to columns), you can apply the same rule to other cells in other columns by copying the format from that cell (or use the paintbrush).

OK.
That works fine.

Thanks for all the help!
:-)


Abdi