Forum Discussion
conditional formating
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 ...
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).