Conditional Formatting - Multiples

[OddProject]

Hi guys,

I have another query.

Ive got my spreadsheet/timeline working how i want it to,

but now I have added a 'Probability' column.

I now need the month-fills colour coded:
Red if -1
Orange if 0
Green if 1

I cant get mine working, It colours the correct cells but also fills the cells I want unfilled with the format set in condition 2.

can someone help me out please?

Below is an attachment of my spreadsheet, hope its enough info for you guys.

Thanks again!

 

[OddProject]

I just cant get it working

Condition 1: is equal to =AND(TRUE, $D$4 =-1)
Condition 2: is equal to =AND(TRUE, $D$4 =0)
Condition 3: is equal to =AND(TRUE, $D$4 =1)

If the cell is 'TRUE' and D4 is '-1' be Green
If the cell is 'TRUE' and D4 is '0' be Orange
If the cell is 'TRUE' and D4 is '1' be Red

The cells i want filling works... but all the other cells i have applied the formatting condition (including 'FALSE' cells) fills with condition 2 (Orange) when I need them unfilled.

not sure if i'm doing this right, but I cant find the solution anywhere and im not sure if im doing this right.

any ideas?

 

[OddProject]

I need the 'FALSE' un filled. And the rest colour coded.

Heres a screenshot for extra help

 

[OddProject]

Here, sorry

 

[namliam]

Your doing "CELL VALUE" equal to "FORMULA"

Try changing the CELL VALUE to "FORMAL IS" and keeping your formula in place though slightly changed

 

[OddProject]

Your doing "CELL VALUE" equal to "FORMULA"

Try changing the CELL VALUE to "FORMAL IS" and keeping your formula in place though slightly changed

Yeah I already tried that

Formula Is =AND(TRUE, N4=-1)
Formula Is =AND(TRUE, N4=0)
Formula Is =AND(TRUE, N4=1)

Its filling the rows I want in the right colour,
but all the 'FALSEs' are filled too...


P.s I'm using a few different sheets to experiment, so obviously cell co-ordinates will differ...

 

[OddProject]

SOLVED:

=IF(P4=TRUE,$N4=-1,)
=IF(P4=TRUE,$N4=0,)
=IF(P4=TRUE,$N4=1,)

Thanks anyways guys