Previous Topic Next Topic

Jhgjhlkj

Closed
nbekdemir - Apr 15, 2010 at 09:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 09:31 AM
I want to make such a formula in excel;

If the value in A column is equal to "+"; then the conditional formatting for the result row should be as;

Result < Target -----> Colour is red


If the value in A column is equal to "-"; then the conditional formatting for the result row should be as;

Result > Target -----> Colour is red

How can I write this formula together with these 2 conditions?

Thanksss




A COLUMN JAN FEB MAR
+ TARGET 41,6 41,6 41,6
RESULT 43,02 43,83 43,75



1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 15, 2010 at 09:31 AM
Not sure what you are asking here

It seem that you would need two conditional formatting formula

select all cells

then go to conditional formatting

enter formula

=A1="+"
and then click on formatting button of the dialogbox and choose color red

then enter another formula in the same way

=A1="-"
and then click on formatting button of the dialogbox and choose the other color