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
RE: Excel conditional formatting
What is ON OD OB
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
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
