Excelrookie86
New Member
- Joined
- Mar 22, 2022
- Messages
- 33
- Office Version
- 365
- Platform
- Windows
Hey you junkies~!
I am trying to format Column J red or green based on the date in column J, and Column N. Basically if it is after today and the Management email has NOT been sent, color RED. If after today and mnmt email WAS sent, then color Green.
Currently I am using
If column N is "Y" and Column J=today0() then color green.
If Column N is "N" and Column J =today0() then color red
I am trying to format Column J red or green based on the date in column J, and Column N. Basically if it is after today and the Management email has NOT been sent, color RED. If after today and mnmt email WAS sent, then color Green.
Currently I am using
If column N is "Y" and Column J=today0() then color green.
If Column N is "N" and Column J =today0() then color red