I have 30 rows by 6 columns, all the cells contain nos. ranging from 6 - 13. I have conditional formatting as follows
6-8 Red fill
9-11 Orange fill
12-3 Green fill

I need to add in to the conditional formatting that if cell B1 is less than A1 it highlights the cell to a different colour and some wording appears asking the person to enter a number in b1 that it the same or higher than the one in A1. I need this to override the red/orange/green formatting for the numbers.

Thanks for any help.