Conditional Formatting

[hotrod]

Formula required for comparing 2 rows of numbers.
If row 10 numbers are less than row 1 numbers, I require the numbers in row 10 to be highlighted.
eg row 1 10.20
row 10 10.01 (would be highlighted)

 

[thisisrahul]

is this what you want...
go to conditional formatting and write the following formula


=if(A$10<A$1,true,false)<A$1,TRUE,FALSE)< p>
set your formatting style and copy the format to all the other cells.



___________
Rahul

 

[Tony Miall]

select cell A10 go to

Format
Conditional formatting
in the drop down box on the left select "Formula is"
Type in =A10>A1

Then select the highlight colour

then copy A10 across row 10

 

[thisisrahul]

=if(A$10<A$1,true,false)

check the formula, i am surprised why it did not came last time.



___________
Rahul

 

[thisisrahul]

can anybody help me out why my formula's are not being displayed fully.

 

[hotrod]

Tony
Thank you, your formula works.

Rahul
I don't know why your formula is not displayed in full.

 

[Mr. Walnuts]

You're using the greater than/less than symbol.

that symbol is also used for HTML formatting on forums so it does not show up because the forum thinks you're formatting your post with it. Use the code function. use the word code with [] around it at the beginning and /code at the end, also with [] around it.

 looks like this <><><><>adsfgvsaes4t23