I have a workbook that gives visualisation of staff Annual Leave. i want to be able to have their name added to the first cell of their A/L where a block is coloured in depending onFormula:
Please Login or Register to view this content.
I have got a formula that works:but I was wondering if there was a more efficient way of this working rather than having this formula in (almost) every cell in the worksheetFormula:Please Login or Register to view this content.
You have to have the formula in almost every cell in the worksheet. The name can appear in any cell depending on conditions, so every cell has to have the formula. The other option would be to use VBA to put it there, but that has no advantage over the formula method and adds complexity.
Not sure what you have going on there in rows 11 & 12, but 3:10 look fine.
You can simplify your conditional formatting rule used to highlight the name. It doesn't have to reproduce the logic you already have in the cell. You can use:
Formula:Please Login or Register to view this content.
By the way, I'm puzzled by the title of this thread. INDEX does not seem to play a role here.
Hi Jazzer
Sorry I was trying to spin too many plates this morning, and dropped most of them
11 & 12 were lines where I added "Blank" just to confirm the formula was working correctly.
I have mode the changes you have mentioned, thank you. i was just wondering if there was a way of forcing the names to show in full - I assume that because I have a formula in the following cell this is "overwriting" the text that would normally be visible if the cell was blank?
The formatting is different than the original. The cells are now very narrow.
Yes, that's correct. Text in a cell will bleed into the next cell only if the next cell is empty (i.e., no value and no formula).
If you want to try VBA I can help with that but I don't want to put any work into it until I'm 100% sure what you want. The problem with what you want to do is that even if you do this with VBA, to put the name only where it is needed and leave the other cells empty, the formatting will probably not be what you're after. The first cell will be conditionally formatting to highlight the name, but the name will bleed into the red cells.
Darryl.jpg
Hi Jazzer
No, that if fine. Thank you for the help. White Bold Text on the red, and with the use of Freeze Panes has made it a lot easier than what I had originally.
Thanks muchly for all the help.
Darryl
Marked SOLVED so no VBA?
Glad to help.
Hi Jazzer.
No. no VBA at this moment. What you have helped with makes it a lot easier than what I had to start with, and it is only used periodically so not worth taking up both of our time, but thanks for the offer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks