
08-07-2014, 05:09 AM
|
Novice
|
|
Join Date: Aug 2014
Posts: 17
|
|
Hello,
Thank you for the help. However, I'm not sure this is possible with my report. - For the cells where I need to apply conditional formating, their is many possibilities of numbers that could be input. For example : Cell O12 and Q12 is identical. But also need rule to say if O12 and S12 or Q12 and S12 are identical. (see my excel report, situation is for the same code twice issue and same code & hours twice issue)
- What would be the rule this?
- I also need a rule when the same hours and same code is used twice. E.g. : N13-O13 would be the same as P13 and Q13. Again, I have 9 combinations possible. What would be the rule for this?
- If there is a number (could be any number) in N7 and no number in O7. I have to put the same rule with P4 and Q4, R4 and S4, etc (total of 9 combinations). (see my excel report, situation for the hours with no code issue)
- If I want to highlight if P11 or R11 is higher than N11.
- Hours are input in the cells N12, P12, R12, V12, X12, Z12, AC12, AE12 and AG12. I want to flag the numbers that are not in 15 minutes increments. Hours can vary between 0,01 hours to 48 hours. So everything outside 0,25 increments needs to be flagged. There are so many possibilities. (see my excel report, situation for the hours conversion not in 15 minute increments)
- Is there a rule that can be applied?
I appreciate any person that will help me 
Thank you!!
|