Just select the whole range that you want to apply this rule to (any possible cell you may enter in cell D12), go to Conditional Formatting, choose the formula option (last one), enter the formula, and select your highlighting color.
The calendar is made like a cross. If something happened I write down the date and what happened. Then it show a color in the cross based on type of problem it was that day.
I use an image as a overlay above the cross so I could see the days.
A neat function would be if I also can highlight the current day with colored frame.
For the moment the images black lines is above excels lines so I have to remove the lines from the picture if there is a formula that can handle this. Otherwise I guess I need to use another picture above the other picture that moves every day. Maybe vba is needed for this kind of function?
As I asked for in my previous post, please walk us through an actual example, step-by-step, based on your images.
That may help clarify what you are trying to do, as it is still not clear to me.
In walking us through an actual example, you will need to tell us:
- Exactly what cell you are updating (tell us the cell address)
- Exactly what you are entering into that cell
- What the expected outcome of that action is (what happens to other cells, providing the details of the cell addresses and exactly what happens to them)
I showed you how to do that in my very first reply. Did that not work for you?
Here are step-by-step instructions on how to do that.
1. Select cells D4:J10
2. Go to Conditional Formatting, and select New Rule then Use a formula to determine which cells to format
3. Enter in the following formula:
4. Click on the Format button
5. Go to the Border tab and select the Outline option
6. Click OK twice.
This will put the highlight around cell G8.
If you cnange the address in cell B23 to any other cell in range D4:J10, it will move the outline to that cell.