conditional formating

[Stephen Klassen]

i have a spreadsheet that tracks the IOU's of my local canteen. I want it to invert the colours when the amount is greater than $10 and completely blackout the whole line when it is over $20. I have 60 people I am tracking. currently I have 2 rules per line per person, a lot of rules. is there a way I can do this with 2-ish rules that apply to the whole worksheet?

[#2]

Hi Stephen,

You need only two rules (one for each formatting) with formulas like

=$A1>20     and
=$A1>10

in order as above and applied to your entire range (sheet).

[#3]

pls see attached file.

hope you can work something out of it.

thanks..