I am looking for help to set up Conditional Formatting so that if you forgets to enter data into a Grid 1 cell without first entering it into Grid 2 a cell will be highlighted in red as a warning.
At the moment an error Warning Label does appear but I would like this extra warning as well.
I have extracted a test workbook from a much larger app and attached it and hope that I have explained sufficiently. If more info is required please ask and I would be very grateful if anyone can help.
Many thanks for looking.