LinkBack URL
About LinkBacks
let's say cell A1 is colored blue manually, how can i format cell b1 to be colored red? is it possible in conditional formatting?
let's say cell A1 is colored blue manually, how can i format cell b1 to be colored red? is it possible in conditional formatting?
If you assign a value like 1 for red and 2 for green like that and enter the 1 in A1 with your manual blue color. Then based on the value in A1 cell we can color the B1 cell with desired color.
Otherwise you have to go for vba solution if you don’t want to enter the numbers in Column-A.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi and welcome to the forum
Formatting (colors, font, bold etc) are cosmetic visual aids for people, and are not data. Excel works with data and does not "see" formatting, so unless you can use something like Six suggested, you will have to go the VBA route
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thanks for your responses. I can't assign values for the first cell because datas will be encoded. cell color is like my indicator that some data will have to be encoded on that cell and am not familiar with VBA.
OK well is there any logic to how/why the 1st cell gets colored? Maybe is there is, we can use that for the 2nd cell (and maybe the 1st 1 too?)
yes. for example, when the cell A1 is colored blue, cell B1 will also be colored (which means there is next information needed). but when A2 is colored red, cell B2 will remain as it is (which means no more next info needed). sorry if i can't explain clearly..
What is the possible number of permutation combination in this case?
In your above case there is only 2 color combinations Red and Blue.
If blue is chosen then red needs to be filled to the next cell.
If Red is chosen then No action
Whether these two color combinations are the only criteria’s OR several like this?
Last edited by :) Sixthsense :); 11-25-2013 at 02:21 AM. Reason: Corrected the are to OR in the sentence
OK but I meant, is there any logic to how the cells in A are colored - the 1's you color manually?Originally Posted by khay0218
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks