I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop.
is there something I can do to get them to pop instantly everytime?
is there something I can do to get them to pop instantly everytime?
Aircraft AD template Remake V2 cond.xlsx | ||||
---|---|---|---|---|
U | V | |||
22 | 35764.00 | 25140 | ||
23 | 37434.00 | 27088 | ||
24 | 35764 | 25140 | ||
25 | 35764 | 25140 | ||
(REPEAT) - REPEAT |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
V2:V1000,Y2:Z1000 | Expression | =IF(AND($V2="",$Y2="",$Z2=""),$S2<>"","") | text | NO |
U2:U1000,X2:X1000,Z2:Z1000 | Expression | =IF(AND($U2="",$X2="",$Z2=""),$R2<>"","") | text | NO |
V2:V1000 | Expression | =IF($V2="","",NOT(ISNUMBER($V2))) | text | NO |
U2:U1000 | Expression | =IF($U2="","",NOT(ISNUMBER($U2))) | text | NO |
V2:V1000 | Expression | =AND($N2="OOP",$S2<>"",$Z2="",$V2="",$Y2="") | text | NO |
U2:U1000 | Expression | =AND($N2="OOP",$R2<>"",$Z2="",$U2="",$X2="") | text | NO |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
U22:U25 | Whole number | >=0 |