arctic brook
how can I format excel to highlight the cells between the text inputs "IN" and "OUT"? i have it to auto format in and out already. just want to highlight the range between them. maybe another program would work better? lmk.
#excel formatting
tardy slate
If I were doing it I'd have conditional formatting where I'd use MATCH to get the column number for "IN" and "OUT" then have an IF to check COLUMN of the cell vs the MATCH of IN and OUT
Might have to play around with it a bit but something like that should work. I don't have excel to hand to test it