How do I accomplish this task?
Suppose I have 1 reference cell R1, and I have 2 columns, C and D, just to make it simple, let’s assume it has only 3 rows,
C1=<5
, C2=5-10
, C3>10
, if my R1 is 6
, then I’d like to put a mark (O for instance) in D2, with background yellow, but if my R1 is 3
, then D1 should have O with yellow color. My initial thought is having an IF on D column to test the values and put an O, and then conditional formatting to change the yellow background, I’m still learning CF (Conditional Formatting), so not sure how to accomplish this. can someone please point me to the right direction? Or is there any tutorial explaining details of CF?
ps: I’ve attached an example with 5 rows to show what I’d like to accomplish.15943082546679422.ods