I'm using 1 cell to enter a code (1 or 2) to identify excused or unexcused absence. I have 2 other cells pulling from this with the hours used for either vacation or sick time.
Col A....Col B....Col C
Sick......Vac......Code
8............0.........2
I want the conditional format to say: =If(A3>0,(If(C3=2),(conditional format fill red),(no fill))).
How do I do this correctly?
Thanks!
Bookmarks