Conditional formatting no higher than 6

[troysie]

I want to format a cell to accept the numbers 1 to 6. If a higher number than 6 is entered I want it to return a 6
Regards Troysie

[DonkeyOte]

If you want to alter the physical value entered into a cell (ie 10 is changed to 6) then you will need to use VBA.

If you want to alter the "appearance" of a value entered into a cell (ie 10 to display as 6) then you can use a Custom Number format to achieve this.

If you want to restrict the users from entering any number > 6 in the first instance use Data Validation.

Please clarify as to which of the above best fits your requirements and we will advise from there.

[troysie]

what I need to do is record 2 values. I will have A1=B1,in A1 iwant to enter a value and it remain the same,but in B1 if the the value in A1 is more than 6 I want it to record six.Probably vba would be the best bet
Regards Troysie

[DonkeyOte]

So perhaps:

Please Login or Register  to view this content.

B1 will thus populate with the lesser of 6 and the value in A1.

[troysie]

Thankyou
Regards Troysie