Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Excel conditional formatting
|
|
|
The UK's most regular 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. |
microsoft excel course - Excel conditional formatting
Resolved · Low Priority · Version Standard
Reply 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
For upcoming training course dates see: Pricing & availability
Reply 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
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
Reply 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
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
Reply Fri 1 Jun 2007, 09:59Delegate Derek said...
RE: Excel conditional formatting
Hi David
Got your reply, thanks for trying.
|