Conditional formatting formula required or hierarchy help

[KClem]

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.

[DBY]

Hello
Conditional Formatting cannot return a message only format the cell(s). You would have to apply Data Validation for an Input Message to appear with a Custom formula such as:

Please Login or Register  to view this content.

DBY

[sktneer]

In the attached input a number in the range A1:F30 (cells with border) and see if this is something you can work with.

[KClem]

sktneer, this is great it does exactly what i need. Is it conditional formatting? I looked at the rules and nothing appeared.

[sktneer]

This is done with a VBA code.
Right click on the Sheet1 Tab --> View code, and you will find a Change Event Code on Sheet1 Module and that does what you were trying to achieve.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under their posts, another way to say thanks.