Hi all,
So I'm creating a worksheet for work, and I'd like to automate some check-boxes so that if the following two columns have ANYTHING written in them, the checkbox automatically gets ticked. I should note I am trying to accomplish this by creating an icon rule that creates a checkmark for anything 1 and above, and an X for anything that equals 0. Then in the cell itself (A1), I'm am writing the equation. The problem is that my equation seems to be overruling the rule, so I see "1" as opposed to my checkmark.
Hope this makes sense. Here is my equation in the cell:
=IF(AND(H4<>"", K4<>""), "1", "0")
Here it what I want to happen, written in plain english:
IF A1 = 1, Checkmark
IF A1 = 2, X
IF B1 and C1 are BLANK, A1=1, otherwise, A=0
Bookmarks