Excel file setup

[Jmesser]

I am using a excel file which involves a group of pages. I need help with 2 formula's. The first formula is i would like to lock the the pulls from other pages so that when i sort either page it will keep the correct value. the other formula i want to use is a fill color change. if its less then a specified value then i want it to be red if it meets or exceeds i want it to be green. I would also like to set it so that if it exceeds by a certain amount it turns blue or some other color.

can anyone help me with these? thank you

[martindwilson]

for the second part you can use conditional formatting. format/conditional formatting. you can set 3 seperate conditions using the add button
eg if cell value is greater than or equal to 6 the cell can be coloured blue
less than 6 coloured red, greater than 20 yellow

[Jmesser]

Thank you for info on the second part. any idea on the first part?