98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Excel conditional formatting
microsoft excel course - Excel conditional formatting
Resolved · Low Priority · Version Standard
Thu 26 Apr 2007, 18:30Delegate Derek said...
Derek has attended:
No courses
Excel conditional formatting
Hi
I have ON OD OB text in three cells taken from one sheet into another but in the new sheet i need to change the formatting to show each cell with ON OD OB to change cell colour and if possible drop the O
Can it be done in 1 condition or will i have to use 3 conditions and how do you do it
Thanks
Derek
Fri 4 May 2007, 14:13Trainer Garry said...
RE: Excel conditional formatting
What is ON OD OB
Fri 4 May 2007, 16:49Delegate Derek said...
RE: Excel conditional formatting
ON OD OB stands for Overtime Nightshift, Overtime Dayshift and Overtime Backshift. it is codes used for a shift rota along with a lot of other codes, i use colours to highlight overtime leave sick etc but can only get each condition in the formatting to change one code eg ="ON" with format Red ="OD" with Red and ="OB" with Red which uses up the 3 conditions.
The question is can the 3 codes be formatted using only 1 condition which will leave 2 conditions for other formatting
Thanks
Derek
Tue 29 May 2007, 09:35Trainer David said...
RE: Excel conditional formatting
Hi Derek
I think that you will nedd to use three conditional formatting statements, however you could write some VBA code to do the formatting for you. You may find the following link helpful.
VBA help
Hope this helps
David
Tue 29 May 2007, 11:47Delegate Derek said...
RE: Excel conditional formatting
Hi David
The VBA code does the trick but is there a way to get the colour to change as soon as you come out of the cell, at the moment i can only get it to change if i come out of the cell and then go back in it
Also i need it to work with letters instead of numbers
Thanks
Derek
Wed 30 May 2007, 14:13Trainer David said...
RE: Excel conditional formatting
Hi Derek
I will have to look into this, as I'm not sure myself. If I find anything out I will get back to you.
David
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |
