shrivallabha
02-16-2011, 10:25 AM
In the last week, I realised how (badly) we have underused Named Ranges and Conditional Formatting up till now.
I am attaching a workbook where I have used conditional formatting. In it, I have used one formula specifically with varying named ranges.
However, I tripped on trying to set conditional formatting on the first column.
1. In this column we use a ID which continues for non-fixed number of rows. Then the user shall enter another ID.
2. After this however, the previous ID should not be used i.e. ABCD in the attached sheets' case.
3. In that case, the first row where the ID is retyped should go red which will tell user that the ID has been used previously (at row 16).
4. This will help user not to repeat the ID entry by mistake and take appropriate action.
I first tried Excel's built in help. But it turned out to be no help :banghead: . As it simply tells us that the formula should yield TRUE or FALSE and there are no examples.
Of course, I can go the VBA way to check things but this art of CF is somehow fascinating me. Thank you in advance.
I am attaching a workbook where I have used conditional formatting. In it, I have used one formula specifically with varying named ranges.
However, I tripped on trying to set conditional formatting on the first column.
1. In this column we use a ID which continues for non-fixed number of rows. Then the user shall enter another ID.
2. After this however, the previous ID should not be used i.e. ABCD in the attached sheets' case.
3. In that case, the first row where the ID is retyped should go red which will tell user that the ID has been used previously (at row 16).
4. This will help user not to repeat the ID entry by mistake and take appropriate action.
I first tried Excel's built in help. But it turned out to be no help :banghead: . As it simply tells us that the formula should yield TRUE or FALSE and there are no examples.
Of course, I can go the VBA way to check things but this art of CF is somehow fascinating me. Thank you in advance.