Oct 23 2018 02:43 PM
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?
Oct 23 2018 03:46 PM
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).
Oct 23 2018 04:06 PM
pls see attached file.
hope you can work something out of it.
thanks..