Microsoft Excel
--
Questions
--
Followers
Top Experts
Setup IF criteria in Excel Spreadsheet
Hello, I have this Excel document I've been struggling with for quite some time now. I would like to have row "N" through row "Q" highlighted in Red with White lettering based on two criteria. The number in column "O" greater than "0" and the Date in column "Q" equal to or less than the date in cell "M1". The reason for using the date in cell "M1" is that I put this date manually each afternoon and print the spreadsheet for the next day for the production line.
Thanks
Spreadsheet.JPG
Thanks
Spreadsheet.JPG
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Can you attach the workbook not an image.
Here it is, thanks
Sealed-Switch-Line-Schedule-Oct-201.xlsx
Sealed-Switch-Line-Schedule-Oct-201.xlsx
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
If its just for printing and highlighting specific lines, how about applying a filter so that only the required lines are visible and therefore printed.
You can filter on Date column for "Earlier than or equal to today" and the Quantity column for "greater than zero".
Your printed report will then be smaller and only show the lines required.
You can filter on Date column for "Earlier than or equal to today" and the Quantity column for "greater than zero".
Your printed report will then be smaller and only show the lines required.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
It worked, thank you!
You're welcome!
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.