View Single Post
 
Old 08-07-2014, 05:09 AM
genevievebr0 genevievebr0 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Aug 2014
Posts: 17
genevievebr0 is on a distinguished road
Exclamation

Hello,
Thank you for the help. However, I'm not sure this is possible with my report.
  1. 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?
  2. 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)
    • What would be the rule ?
  3. If I want to highlight if P11 or R11 is higher than N11.
    • What would be the rule?
  4. 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!!
Reply With Quote