Excel 2003 or 2010 - Data Validation of (dropdown) List re text with a background colour & font size.
When an item is selected from the list, is there any way to:
(1) bring across the colour?
(2) display dropdown list (when selecting) as a larger font size?
I just realised that re (1) I could probably put conditional formatting on the target cells, which would be based upon the populated cell from the selection. Correct? I would prefer it just to come across with the selection, if possible & without VBA code?
Per (2) I know the user could zoom out the screen so they could actually see the drop down list content, but that is very inconvenient.
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How can you see what you are working on when you want to see it while you to save a copy?
Add a "Save As" icon to the Quick Access Toolbar, or QAT.
That way, when you save a copy of a query, form, report, or other object you are modifying, you…