Forum Discussion

Stephen Klassen's avatar
Stephen Klassen
Copper Contributor
Oct 23, 2018

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 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?

excel
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Oct 23, 2018

    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).

Resources