First I would like to thank Aquarelle for her kind words, regarding asking questions.
I'm working on a calender where each day has a different color according to the dayname. When I alter the worksheet for next year, each date gets a different dayname. Since I also implemented holidays into the calender I've given each day a colorcode: 1=monday, 2=tuesday, 3=wednesday, 4=thursday, 5=friday, 6=weekend, 7=holiday.
Now I've put the days in columns and the colorcode in a row. So it looks like this (I'm using ' for spacing):
Ma''Di''Wo'=Dayname
14''15''16''=day of the month
1''''''2'''''''3''''=colorcode
Below this I've put names, so I can input their free days.
Now I want to change the color of the entire column according to the colorcode. This works great with conditional formating; Select entire row, condition: formula is ... etc.. But as known, conditional formating only has three conditions.
I've found lots of answers about conditional formating with more than three conditions, But I can't find an answer for coloring rows according to the condition of 1 cell.
Hope your are well now. Here is the file, I loaded it on a french deposite file website because time is unlimited :
http://www.cijoint.fr/cjlink.php?file=cj200906/cijrcx9d3Z.xls
(The conditional formats are on the worksheet named "Januari" in cells C7 to AG7)
See you :)
Hello Trowan,
Happy to see you coming back here. Please could you load a brief example of your excel file (without any private or personal data) on https://authentification.site then copy past the created link to your next answer.
Because to create a macro, I need to know where and how are organised the different data.
See you soon.
Happy to see you're willing to help me once again.
Just to be complete, I've uploaded the entire file (without names).
I was asked to create a file to register the vacationdays of the company employees.
Now I'm trying to prepare the file for the years to come.
Unfortunatly the file is in dutch, so you might not understand everything.
Take a look at the worksheet named "Januari".
The colorcodes are in row 7. To keep the sheet clear, the textcolor is white.
So according to the colorcode in C7, I want to color C5:C6, C8:C200.
And according to the colorcode in D7, I want to color D5:D6, D8:D200, and so on.
I've already looked up the colornumber used in excel, which can be found in worksheet "Gegevensblad", starting in cell U2.
Hi
To conditional format an entire row based on a single cell's content lock the cell (eg $A23) in the condition and the range to apply select the entire row
You are the greatest!
Issue solved.