I am looking for a formula to conditional format the cells that contain text in Column A based on next week's date (Row 2) and the number located in a specific cell in the column under the specific date. Attached is example spreadsheet.
I am looking for a formula to conditional format the cells that contain text in Column A based on next week's date (Row 2) and the number located in a specific cell in the column under the specific date. Attached is example spreadsheet.
Hi and welcome to the forum
You'll need to offer a few specific examples identifying cells that need formatting and if it's not obvious, why.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
I am needing the Name in Column A highlighted based on the NEXT WEEKS Billable hours being less than 24 hours. The issue is the date would be constantly changing
Example: I am looking at spreadsheet today (02/05/2020). Anyone with billable hours under 24 hours in week 02/10/2020 would need to be highlighted.
When I look at spreadsheet next week (02/12/2020), anyone under 02/17/2020 would need to be highlighted.
I am needing the Name in Column A highlighted based on the NEXT WEEKS Billable hours being less than 24 hours. The issue is the date would be constantly changing
Example: I am looking at spreadsheet today (02/05/2020). Anyone with billable hours under 24 hours in week 02/10/2020 would need to be highlighted.
When I look at spreadsheet next week (02/12/2020), anyone under 02/17/2020 would need to be highlighted.
Hi use this CF in A4, choose a colour to paint the cell and copy the format to rows 10, 16, 22...etc
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks