ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
WHAT IF I WANT THE DATE BEFOER FORMULA TO MAKE THE CELL TURN RED ONLY 7 DAYS BEFORE THE DATE IN THE CELL?
It’s a bit more complicated. Conditional Formatting, New Rule, use a formula to determine which cells to formulate. Then type =$A1
WHAT IF I WANT THE DATE BEFOER FORMULA TO MAKE THE CELL TURN RED ONLY 7 DAYS BEFORE THE DATE IN THE CELL?
It’s a bit more complicated. Conditional Formatting, New Rule, use a formula to determine which cells to formulate. Then type =$A1