Claude Constantinescu
asked on
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
Can you attach the workbook not an image.
ASKER
Here it is, thanks
Sealed-Switch-Line-Schedule-Oct-201.xlsx
Sealed-Switch-Line-Schedule-Oct-201.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
It worked, thank you!
You're welcome!