Need help with conditional formatting over multiple sheets

Good morning everyone.

I am new here, but have used this forum for plenty of help lately, but can't seem to find the solution to my problem.

I am making a calendar for our dispatch center. I have all of our badge numbers, and our days worked in all of the sheets, and that works fine.

I made some conditional formatting to highlight cells based on the previous cell's text.
Example
If someone is sick, I type in sick and their number turns red, yellow for vacation, blue for holiday, etc.

I have the whole month of January done and everything works fine. I just can not find any way to get this all to carry over to the other months in my calendar.

I have tried everything that was suggested, and unless I am doing something wrong here I can't get it to work.

Any help would be greatly appreciated.

Thanks for the reply. I'm sure it could have been done better, but that's all I knew how to do.

Cell G6 I have typed in Shift Adjust, this highlights cell H6 to turn Green.
So any of the blank cells are typeable and if the correct value is typed in the number following it should change color.

If there is a much easier or better way to do this, I would love to hear it.

I just need the number, 353,354,355, etc to change color if text is entered into the previous cell. For sick,vacation,holiday, etc.

That make sense?

I tried both of those and I'm still not getting the results I am looking for. I know it is something I am doing wrong.

If you looked at the spread sheet I want to be able to type sick in a cell and have the next cell which should contain our "badge number" and have that auto fill to be red. I want to repeat this for all of the other "reasons" for being colored.

If there is a much easier way to do this, I would love to learn how. I am no Excel expert, I know when I'm in over my head, and I am this time. I started with a simple calendar and it turned into this. Now that I have January done correctly, the boss expects the other 11 months to look the same.

Any help is greatly appreciated here. Macro, etc, doesn't matter to me.

Originally Posted by dogberry

Hi

When you have followed Dilipandeys advice also consider the format painter, if that fails have a look at http://www.excelforum.com/excel-gene...worksheet.html

Hope that helps


Chris