Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am using all 3 conditions so is there a way to combine these 2 lines of
code into 1 condition? They both result in turning the cell red: '(this line looks to see if there is a percent other than 0 or 100 and calculates the percent where we should be versus the actual, cell H33) =IF(AND(H330%,H33<100%),(H33<=((H32-$C$2)/$H$8))) OR =IF(H33=0%,(H32-$C$2)<$H$8) '(this line looks to see if there are still enough days to complete) Cell H33 is a % Comp, H32 is End Date, $C$2 is Today's Date and $H$8 is # days to complete, just FYI. THANKS!! Stacey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |