Conditional format problem

[Gazzal]

How can I conditionally format numbers in H col if row value is 100% and if RC[-2] (F col) value = J9

 

[Montrey]

=if(and(rowvalue=1,F9=J9),true,false)

 

[Gazzal]

Thanks Montrey, I tried to enter this if(and(rowvalue=1,F9=J9) as a formula in conditional formating and nothing happens. The F9 value is to be tested on each row (not static F9)

Basically, if a row value in H col = 100% and the same row value in F Col = value in J9 (static) then highlight value in pink background color.

How do I write it so the F9 value is relative to each row

 

[Hui]

Gazzal


I think it should be

=And(Rowvalue=1,F9=$J$9)


It doesn't need the If() to surround the formula


If this doesn't help can you post your file so we can see what is going on.

 

[Gazzal]

Thanks Hui

But it does nothing, here is a link to a sample sheet;

http://speedy.sh/vk8AB/LeagueTest.xls


If F value = J9 value and H >70% - cond. format H value pink

 

[SirJB7]

Hi, Gazzal!


Give a look at this file:

http://dl.dropbox.com/u/60558749/Conditional%20format%20problem%20-%20LeagueTest%20%28for%20Gazzal%20at%20chandoo.org%29.xls


Regards!

 

[Gazzal]

Thanks SirJB7, would not function but after some playing around I managed to get your formula to work. Must have had previous CF on the row stopping it from working possibly?. Looks good now, that's awesome!

 

[SirJB7]

Hi, Gazzal!

Glad you solved it. Thanks for your feedback and for your kind words too. Welcome back whenever needed or wanted.

Regards!