I would like to conditionally format multiple cells to be a particular colour, depending on the colour of another cell which will be changed manually and without a formula.
I would like to conditionally format multiple cells to be a particular colour, depending on the colour of another cell which will be changed manually and without a formula.
Basically, It requires VBA code and is by no means an easy task, as change of color of the fill or the text do not start event "Change" as changing value do.
So first advice is to rething and may be change concept to use standard conditional formatting (as it relates to other cells - with a rule based on formula).
Second is - prepare representative sample and attach workbook here. (10-20 rows of data is usually enough) Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).
3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!
To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
Best Regards,
Kaper
I think I have attached a very simple example of the sort of thing I would like to do. Thanks!
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks