bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 701
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I have a schedule which contains draws we need to pay our new reps.
In row 1, I have the following formula in K1 using conditional formatting for the current the commission month : EOmonth(Now(),1).
If it is false, nothing is shown (L1-O1)
In row 2, right below the formula I have a month that the draw is due to paid.
In this example, I need column K to be highlighted. All the other columns are not highlighted in yellow, only column K (the month name that is visible - I have conditional formatting in row 1 which shows the month that we are paying commissions).
Next month, K becomes un-highlighted but column L becomes highlighted instead. I would like to make the column highlight per above.
Is there a formula that I could use which will do this?
Thank you in advance for your help,
Michael
In row 1, I have the following formula in K1 using conditional formatting for the current the commission month : EOmonth(Now(),1).
If it is false, nothing is shown (L1-O1)
In row 2, right below the formula I have a month that the draw is due to paid.
In this example, I need column K to be highlighted. All the other columns are not highlighted in yellow, only column K (the month name that is visible - I have conditional formatting in row 1 which shows the month that we are paying commissions).
Next month, K becomes un-highlighted but column L becomes highlighted instead. I would like to make the column highlight per above.
Is there a formula that I could use which will do this?
Thank you in advance for your help,
Michael